Pinal Dave - SQL Server Performance Tuning Expert

Interview Question of the Week #025 – How to Implement Paging in SQL Server?

June 21, 2015

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Here is a very popular question when SQL Server interview consists of live coding example. Question: How to implement paging in SQL Server? Explain with the help of script. Answer: Here is the script to implemented paging in SQL Server 2005. USE AdventureWorks GO DECLARE @StartRow INT DECLARE @EndRow INT…

SQL SERVER – Using PowerShell and Native Client to run queries in SQL Server

June 20, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Powershell, SQL Scripts

I have been getting my hands dirty working with PowerShell commands for a fun learning experience and few have made to this blog. The after effect of this is that I have been pinged for few queries on them too. Recently I got a call from one of my friend…

SQL SERVER – Database Snapshots and Replica Causing Write Delays

June 19, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Snapshot, SQL Backup and Restore

For folks who have not worked with SQL Server Database snapshot feature, please refer to the blog I wrote sometime back (SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot). I am giving this reference because some might not be aware of this powerful capability with…

SQL SERVER – Converting Standard SSMS File Results to Delimited – Notes from the Field #085

June 18, 2015

Pinal Dave

SQL

C Sharp, Notes from the Field, SQL Function, SQL Scripts, SQL Server

This is an 85th episode of Notes from the Field series. SSMS is my favorite IDE. I work with many different databases and different IDE. However, I get extreme comfort when I am working with SSMS. Though I like SSMS does not mean it is the best tool and it can accomplish all the tasks when I want it to do. Here is one of the task – converting file results to comma delimited result. However, my friend Kevin came in the rescue. He helped me out in this situation.

SQL SERVER – Stress free life with Spotlight for SQL Server DBA

June 17, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Dell, SQL Backup and Restore

Being on the cutting edge of technology is something that we need to be prepared as IT professionals. Newer capabilities get into the software almost every single day and it is difficult to keep track of what is getting added into the software’s we work with. I am a firm…

SQL SERVER – SPARSE Property Doesn’t Carry Forward Using SELECT INTO

June 16, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

During one of the recent posts on a SQLBangalore UG FB page, one of the members asked an interestingly simple question. He was asking why is it that when you use SELECT-INTO to create a new table the triggers are not getting carried forward as part of the definition. A…

SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1

June 15, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Error Messages

I have been monitoring some of the error messages that SQL Server has been throwing in the recent versions and they are self-explanatory. If we understand the English, then half the problem is solved. It becomes easier and quicker for an administrator if they ever encounter such errors. This blog…