Validating an SQL query programmatically, with gotcha(www.adathedev.co.uk)

submitted by AdaTheDev(123) 1 year, 10 months ago

How to programmatically validate an SQL query without executing it, but with a gotcha... read more...

add a comment |category: Database |Views: 15

tags: SQLServer SQL Database another

Srink, MDF, NDF and Reader's Opinion - What's Yours?(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 11 months ago

Blog Reader and SQL Expert Imran has wonderful explanation of how Srinking, MDF and NDF works. What is your opinion? read more...

add a comment |category: Database |Views: 6

tags: SQLAuthority pinaldave SQLServer Database SQL another

Reality - Stored Procedure and Transactions(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 11 months ago

Learn the truth behind following statement - “I do not use Transactions in SQL as I use Stored Procedure“. read more...

add a comment |category: Database |Views: 450

tags: SQLAuthority pinaldave SQLServer Database SQL another

EAV and the .NET Framework(mahdi.mp)

submitted by sharplife(4570) 1 year, 11 months ago

A wrapup on Entity-Attribute-Value pattern in databases and current .NET framework implementations available. read more...

add a comment |category: Database |Views: 557

tags: SQLServer EAV Database .Net another

Database Deadlock Mystery Resolved - Snapshot Isolation (blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

A Simple Solution to Resolve Database Deallocking and Blocking Issues read more...

add a comment |category: Database |Views: 370

tags: SQLAuthority pinaldave SQLServer Database SQL another

SQL SERVER – Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server. This script is very basic and very simple, there are many different versions are available online. This basic script does do the job which I expect to do – find out the most expensive queries on SQL Server Box. read more...

add a comment |category: Database |Views: 484

tags: SQLAuthority SQLServer SQL Database pinaldave another

Find Most Expensive Queries Using DMV(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

Mystery Resolved - One Query to Find Most Expensive Database Query - DMV read more...

add a comment |category: Database |Views: 12

tags: SQLAuthority SQLServer SQL Database pinaldave another

Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

A Story of Disabled Index read more...

add a comment |category: Database |Views: 8

tags: SQLAuthority SQLServer SQL Database pinaldave another

Download Microsoft SQL Azure Frequently Asked Questions (FAQ)(beyondrelational.com)

submitted by jacobsebastian(3639) 2 years ago

If you are struggling with a SQL Azure problem, one of the first resource to refer is the Microsoft SQL Azure FAQ document which presents a number of commonly asked SQL Azure questions along with a very detailed answer to each of them. read more...

add a comment |category: Database |Views: 135

tags: SQLInjection SQLServer Database SQL another

Get Latest SQL Query for Sessions(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

This is number one request from any developer regarding how to see what was the latest query for that session. read more...

add a comment |category: Database |Views: 275

tags: SQLAuthority SQLServer SQL Database pinaldave another

What is AdventureWorks? - The known and the Unknown Story(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

The known and the Unknown Story read more...

add a comment |category: Database |Views: 49

tags: SQLAuthority SQLServer SQL Database pinaldave another

SQL SERVER – GUID vs INT – Your Opinion(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years ago

Take your side. State your case. Learn the reality. read more...

1 comment |category: Database |Views: 773

tags: SQL SQLAuthority SQLServer pinaldave Database another

SQL Server 2008 R2 Released – Download it or try the Hosted Version(beyondrelational.com)

submitted by jacobsebastian(3639) 2 years, 1 month ago

SQL Server 2008 R2 is officially released. See this post for a number of resources to help you to get started with SQL Server 2008 R2. read more...

add a comment |category: Database |Views: 340

tags: beyondrelational R2 Database SQLServer another

Create Primary Key with Specific Name when Creating Table(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 1 month ago

Does your PK has big long not readable name? Well this is quick post to save the day! read more...

add a comment |category: Database |Views: 273

tags: SQLAuthority SQLServer SQL Database pinaldave another

Adding breadcrumbs to your drillthrough reports (SSRS)(beyondrelational.com)

submitted by jacobsebastian(3639) 2 years, 1 month ago

This post shows a trick that helps you to build breadcrumbs in SSRS drill through reports. read more...

1 comment |category: Database |Views: 345

tags: BI beyondrelational MSBI SSRS Database another

FOR XML Workshop – Understanding FOR XML RAW(beyondrelational.com)

submitted by jacobsebastian(3639) 2 years, 1 month ago

This post explains how to generate XML documents using FOR XML RAW from TSQL (SQL Server) read more...

add a comment |category: Database |Views: 56

tags: XML beyondrelational Database SQLServer another