SQL SERVER - 2005 - Create Script to Copy Database Schema and All The (blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 9 months ago

This is very simple but powerful. Explained with Images. read more...

6 comments |category: Database |Views: 193

tags: SQL SQLAuthority DBA pinaldave Database another

Editing large scripts with Sql Management studio(uilol.blogspot.com)

submitted by szunyog(5) 4 years, 9 months ago

Problems while editing large scripts with Sql Management studio. read more...

add a comment |category: Visual Studio |Views: 6

tags: SqlServer2005 VisualStudio another

Use a CTE along with ROW_NUMBER() to Paginate Records in SQL 2005(blog.troyd.net)

submitted by powerrush(3873) 4 years, 9 months ago

You may be familiar with ROW_NUMBER(), but did you know you'll also need to combine that with a Common Table Expression (CTE) to paginate through your records? read more...

add a comment |category: Database |Views: 15

tags: 2005 SQLServer SqlServer2005 .Net ASP.NET another

SQL SERVER - User Defined Functions (UDF) to Reverse String - UDF_Reve(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 9 months ago

UDF_ReverseString User Defined Functions returns the Reversed String starting from certain position. First parameters takes the string to be reversed. Second parameters takes the position from where the string starts reversing. Script of UDF_ReverseString function to return Reverse String read more...

add a comment |category: Database |Views: 7

tags: SQLServer SQL DBA pinaldave SQLAuthority another

SQL SERVER - Data Warehousing Interview Questions and Answers Complete(blog.sqlauthority.com)

submitted by pinaldave(9662) 4 years, 9 months ago

SQL Server Data Warehousing interview questions and answers were original published in three series. This complete series is combined in one article which is listed here in this article. This article is PDF which is available to download for free. Interview Questions and Answer PDF contains questions from beginner to advance users. Visit complete series as well as final link to download the PDF. read more...

add a comment |category: Database |Views: 349

tags: SQL SQLServer DBA pinaldave SQLAuthority another

SQL Server 2005: How to successfully shoot yourself in the foot with S(weblogs.sqlteam.com)

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

What to do when your CPU is at 100%, your I/O is going nuts and you know Service Broker has something to do with it. read more...

add a comment |category: Database |Views: 4

tags: ServiceBroker Queues Asyncronous SQL 2005 another

Centralized Asynchronous Auditing with Service Broker(sqlteam.com)

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

Service Broker is a new feature in SQL Server 2005. It is an integrated part of the database engine and it provides queuing and reliable direct asynchronous messaging between SQL Server 2005 instances only. In the future this is planned to be extended to non-SQL Server instances. This article shows how to use Service Broker and triggers to capture data changes. read more...

add a comment |category: Database |Views: 30

tags: ServiceBroker Queues SOA SqlServer2005 another

SQL Server 2005: Hypothetical index - a what?!?! (weblogs.sqlteam.com)

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

Yes there is such a thing. It's an index created by the DTA (Database Tuning Advisor) read more...

add a comment |category: Database |Views: 28

tags: DTA SqlServer2005 Index another

Multiple Active Result Sets (MARS) – Transactions and Debugging (weblogs.sqlteam.com)

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

A follow up on my previous post about MARS. Here i explain how transactions in MARS work and how to troubleshoot problems that arise. read more...

add a comment |category: Database |Views: 12

tags: SqlServer2005 MARS Transactions another

SQL Server 2005: Easily importing XML Files (weblogs.sqlteam.com)

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

how to import XML files very easily into SQL Server 2005 with openquery. read more...

add a comment |category: Database |Views: 353

tags: import SqlServer2005 XML OpenRowset another

SQL Server 2005: Concat values XML Style (weblogs.sqlteam.com)

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

Just another way of contencating columns in sql server. the difference is that this can be used inline and it doesn't have to be a function. read more...

add a comment |category: Database |Views: 28

tags: Concat SqlServer2005 XML another

SQL Server 2005: How to have a Unique Constraint with multiple NULLS o(weblogs.sqlteam.com)

submitted by spirit1(3160) 5 years ago

Ever wanted to have have a table that contains unique values but needs to have multiple null values also? read more...

add a comment |category: Database |Views: 4

tags: MultipleNulls UniqueConstraint SqlServer2005 another

Extending DateTime to include dates less than 1753-01-01 in SQL Server(weblogs.sqlteam.com)

submitted by spirit1(3160) 5 years ago

How to extend sql server 2005 datetime range to .net datetime range with the help of CLR User Defined Types (UDT's) read more...

add a comment |category: Database |Views: 28

tags: SqlServer2005 UDT CLR DateTime another