delete duplicate records in sql server table(logiclabz.com)

submitted by webtips(265) 2 years, 9 months ago

delete duplicate records in sql server table with or without primary key read more...

add a comment |category: Database |Views: 45

tags: table Delete duplicate SqlServer2005 Database another

Microsoft SQL Server 2005 SP3 Released(blogs.msdn.com)

submitted by sharplife(4570) 3 years, 5 months ago

Microsoft released Service Pack 3 for SQL Server 2005. read more...

add a comment |category: Database |Views: 21

tags: SqlServer2005 Microsoft Database another

Table-Value Parameters in SQL Server 2005(dotnethitman.spaces.live.com)

submitted by misbaharefin(845) 3 years, 9 months ago

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 how to pass in Table-Value Parameters in SQL Server 2008 but what if we have a need to pass in multiple rows of data to a T-SQL statement, or a routine such as stored procedure or function in SQL Server 2005? read more...

add a comment |category: Tips & Tricks |Views: 224

tags: SqlDbType.Xml SqlServer2005 Database another

Working with tempdb(weblogs.sqlteam.com)

submitted by kprernn(1445) 3 years, 11 months ago

Link to a good TechNet article that thoroughly discusses tempdb in SQL Server 2005. A good read. read more...

1 comment |category: Database |Views: 16

tags: SqlServer2005 SQL Database another

Ease your SSMS experience: SSMS Tools PACK 1.0 is out!(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years ago

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. read more...

add a comment |category: Database |Views: 259

tags: SQLServer2000 SSMS sqlserver2008 Database SqlServer2005 another

SQL Server 2005: Get full information about transaction locks(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years ago

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... read more...

add a comment |category: Database |Views: 60

tags: SqlServer2005 Locks Database Transactions another

SQL Server in One Page - Download it Now(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years ago

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. Download SQL Server FAQ Sheet in PDF format read more...

4 comments |category: Database |Views: 172

tags: SQLAuthority pinaldave SqlServer2005 Database SQLServer another

Switching from Non-IDENTITY to IDENTITY and vise versa(sqlserveruniverse.com)

submitted by ssuniverse(10) 4 years, 3 months ago

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. read more...

add a comment |category: Database |Views: 10

tags: SqlServer2005 SQL Database another

How SQL Server short-circuits WHERE condition evaluation(weblogs.sqlteam.com)

submitted by spirit1(3160) 4 years, 3 months ago

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. read more...

add a comment |category: Database |Views: 19

tags: n00b Shit NotShortCircuit Database SqlServer2005 another

Does the order of criteria the WHERE clause matter?(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 3 months ago

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. read more...

add a comment |category: Database |Views: 38

tags: SqlServer2005 TSQL Database another

Moving a Notification Services database(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 3 months ago

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. read more...

add a comment |category: Database |Views: 4

tags: SqlServer2005 SSNS SQLServer Database SQL another

Does the order of columns in an index matter?(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 3 months ago

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. read more...

add a comment |category: Database |Views: 17

tags: SQLServer SqlServer2005 indexes Database SQL another

Using CROSS JOIN to generate test data(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 3 months ago

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. read more...

add a comment |category: Database |Views: 39

tags: T-SQL SqlServer2005 SQLServer Database SQL another

Using the SSNS Management.SMO NameSpace(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 3 months ago

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. read more...

add a comment |category: C# |Views: 9

tags: SqlServer2005 SSNS SQLServer C# SQL another

Do I need to compact my SQL Server database?(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 4 months ago

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. read more...

add a comment |category: Database |Views: 17

tags: MSAccess SqlServer2005 access Database SQL another

SQL Server error messages(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 5 months ago

Ever needed to find the text associated with an error number in SQL Server? This blog shows you how to retrieve it from SQL Server's metadata using T-SQL. read more...

add a comment |category: Database |Views: 2

tags: SQLServer T-SQL SqlServer2005 Database SQL another