SQL Archives - Page 120 of 519 - SQL Authority with Pinal Dave

SQL SERVER – FIX – Export Error – ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

June 24, 2015

Working with Excel files can always be of great interest. I have not seen a reporting solution in the world that doesn’t give an option to export to excel. If you are talking about two separate solutions and you want to export and import, then such options can be of…

SQL SERVER – Evaluation Period Has Expired – How to Activate SQL Server?

June 22, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Sometimes we are in a hurry that we forget activities that are pending. A typical example would be like walking into a room and we keep thinking about why we were there in the first place. Isn’t that common? Or I think age is catching on me for sure. Some…

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

June 21, 2015

Pinal Dave

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

SQL Scripts

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…