|
|
Stories recently tagged with 'SQLServer'
|
|
submitted by
spirit1
1 day, 8 hours ago weblogs.sqlteam.com — In my previous post about immediate deadlock notifications in SQL Server 2005 I've shown a way to use a try catch block to get the deadlock error.
The con of this method, although it uses best practice for error handling in SQL Server 2005, is that you have to change existing code and
it doesn't work for non stored procedure code. And that IS a pretty BIG con! So here's a solution to this con.
read more...
add a comment
|
category:  Database | Views: 3
| 
|
tags:
Database, SQLServer, 2005, 2008 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
5 days, 8 hours ago weblogs.sqlteam.com — Here's a demo of a nice little bug in SQL Server 2005 when using LIKE comparisons for searching.
What is so "nice" about it is that it only manifests itself if your search ends in number 9 followed by a wildcard when
selecting only columns covered by a nonclustered index.
read more...
add a comment
|
category: Database | Views: 9
| 
|
tags:
SQLServer, Database, 2005 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 7 days, 19 hours ago, submitted by
 Jemm
8 days, 9 hours ago blogs.msdn.com — "We were recently in a review where the ISV was using both SQL Server and MySQL. Of course working for Microsoft my first question was to ask why they had chosen to use MySQL." read more...
1 comment
|
category: Database | Views: 796
| 
|
tags:
SQLServer, MySQL, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Marlonr
9 days, 9 hours ago dbalink.wordpress.com — For some reasons, DBA’s need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes.
Here we are going to rename our Database named “Bad_Ass_DB” into “Best_Practice_DB”. This is how Database renaming with TSQL is done in SQL Server 2005....
read more...
add a comment
|
category: Database | Views: 4
| 
|
tags:
SQLServer, TSQL, SQL, 2005, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
Askeeto
11 days, 7 hours ago foxtricks.blogspot.com — Using temp tables in Microsoft SQL Server is tricky when your databases don't follow the server collation. This post explains how to create temp tables while avoiding the use of explicit COLLATE statements in your TSQL code. read more...
add a comment
|
category: Database | Views: 2
| 
|
tags:
TempTable, SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 wisemx
14 days, 22 hours ago msdn2.microsoft.com — The Microsoft data platform is made up of a rich set of products and technologies for all types of data, from unstructured binary data on one end of the spectrum to highly structured online analytical processing (OLAP) cubes on the other. While these technologies address any application scenarios you may have, typically it involves an up-front investment of time and hardware resources before you are able to start coding your solution. read more...
add a comment
|
category: Database | Views: 6
| 
|
tags:
SQLServer, OLAP, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 14 days ago, submitted by
 justin_etheredge
16 days, 3 hours ago codethinked.com — Sure, SQL Server 2008 is getting ready to drop, but are you familiar with all of the new features that 2005 gave you? Or maybe you haven't used 2005, well, this is a good article to introduce to you several of the new features in SQL Server 2005. read more...
add a comment
|
category: Database | Views: 415
| 
|
tags:
SQL, SQLServer, CodeThinked, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
StatisticsIO
16 days, 21 hours ago statisticsio.com — "Microsoft has told several large database shops to expect their final SQL Server 2008 bits this week. That means it's possible, in an ideal world, that the company will announce RTM (release to manufacturing) of the new database next week at the Microsoft Worldwide Partner Conference. (Microsoft is holding to its official "it'll ship in Q3" story.)"
read more...
1 comment
|
category: Database | Views: 6
| 
|
tags:
SQLServer, Database, 2008 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
paul_houle
19 days, 4 hours ago gen5.info — This article presents a simple stored procedure which makes it possible to delete a stored procedure in SQL Server without knowing it's name, an important tool when automating the maintainance of database schemas in Microsoft SQL Server read more...
add a comment
|
category: Database | Views: 7
| 
|
tags:
SQLServer, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
croland
20 days, 15 hours ago statisticsio.com — Good overview of the upcoming 71-432 SQL Server 2008 Implementation and Maintenance exam. With the constant stream of exams being pumped by Microsoft it's great to have an idea of what's coming down the pipeline. read more...
1 comment
|
category: Database | Views: 46
| 
|
tags:
Database, SQLServer, Certification, 2008, 71-432 | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 crpietschmann
22 days, 20 hours ago pietschsoft.com — The Community Coding Contest will run from July 1 through Sept. 30, 2008. The community will vote to decide the winners. The top 3 entries will each be awarded 1 MSDN Premium Subscription with Visual Studio Team Suite, and the 4th place entry will be awarded Windows Vista Ultimate SP1 and Visual Studio 2008 Professional. Here's an awesome chance to write some code and win some awesome prizes! I am also looking for sponsors to donate additional prizes to give away. read more...
add a comment
|
category:  Community | Views: 9
| 
|
tags:
SQLServer, VisualStudio, Community, contest | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|