By tag: SqlServer2005
0
kicks
delete duplicate records in sql server table
delete duplicate records in sql server table with or without primary key
0
kicks
Microsoft SQL Server 2005 SP3 Released
Microsoft released Service Pack 3 for SQL Server 2005.
0
kicks
Table-Value Parameters in SQL Server 2005
In pre-SQL Server 2005 in order to pass in a set of values one had to create a temporary table, populate it with data using INSERT, and then just use it in the procedure or function since they are created for the current session and are available to all processes in that session.
I did a blog on...
0
kicks
Working with tempdb
Link to a good TechNet article that thoroughly discusses tempdb in SQL Server 2005. A good read.
0
kicks
Ease your SSMS experience: SSMS Tools PACK 1.0 is out!
A popular free add-in for SQL Server Management Studio (SSMS) is now in release version 1.0.
With many new and improved features it speeds up your SSMS development.
0
kicks
SQL Server 2005: Get full information about transaction locks
Get information about what locks are being held by the transaction, what SPID owns the transaction, on which objects the locks are being held, what SQL statement caused the locks, etc...
0
kicks
SQL Server in One Page - Download it Now
One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion and suggestion.
Downloa...
0
kicks
How SQL Server short-circuits WHERE condition evaluation
As a developer you must be aware that SQL Server does not do short-circuiting like it is done in other programming languages and there's nothing you can do to force it to.
0
kicks
Switching from Non-IDENTITY to IDENTITY and vise versa
There may arise situations where it is necessary to switch a field from IDENTITY to non-IDENTITY, and sometimes the other way round. This article discusses these situations on how you were able to do it using SQL Server 2000, and how it can be done now in SQL Server 2005.
0
kicks
Does the order of criteria the WHERE clause matter?
Does the order of the search criteria make any difference in Microsoft SQL Server's ability to use indexes or resolve a query? In this post, Joe provides a demonstration of how SQL Server can optimize the WHERE clause to its benefit.
0
kicks
Moving a Notification Services database
Moving a SQL Server Notification Services database can be a bit tricky. This blog steps you through the required steps to move the instance and application databases to new locations.
0
kicks
Does the order of columns in an index matter?
In this blog Joe answers the question, 'does the order of columns in an index really matter?' He provides several examples and shows the results of the Query Execution Plan.
0
kicks
Using CROSS JOIN to generate test data
In this blog, Joe demonstrates the power of the CROSS JOIN and how it can be harnessed to create lots of test data very quickly.
0
kicks
Using the SSNS Management.SMO NameSpace
In this posting, Joe demonstrates how the Management.SMO namespace may be used to manage an SSNS instance. The soucecode to a brief C# application is provided as an example.
0
kicks
Do I need to compact my SQL Server database?
This is a question frequently asked by those who have used Microsoft Access. This blog posting goes through some great examples to prove that SQL Server can and does automatically reuse space, even after you delete rows.