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

SQL SERVER – Difference Between Read Committed Snapshot and Snapshot Isolation Level

July 3, 2015

It is quite common that when a new feature gets introduced, there is a lot of talk about them. Sometimes even the old capabilities are lesser known because they can be used interchangeably in conversations. I have seen many DBAs getting confused between these two terms because both of them…

SQL SERVER – Why Haven’t You Disabled CPU Power Saving Yet?! – Notes from the Field #087

July 2, 2015

Pinal Dave

SQL

Notes from the Field, SQL CPU, SQL Server

[Note from Pinal]: This is an 87th episode of Notes from the Field series. Every week, I personally wait for the notes from the fields from Mike because it contains lessons of life which directly impacts DBA and Developer’s life positively. Mike Walsh is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn something as a human. He is always looking for an opportunity to improve the life of DBAs and Developers. Let us learn about Disabled CPU Power Saving.

SQL SERVER – Steps to Generate Windows Cluster Log?

July 1, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Log

Every now and then I sit next to DBA to learn some of their tricks. One of this recent learning is what I plan to share here. It is tough to learn everything all by ourselves, so learning is best done by sharing. There are many incidents with SQL cluster…

SQL SERVER – Knowing the Source Application Using APP_NAME() Function

June 30, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

APP_NAME() function in SQL Server returns the application name of the current session in which it is called. When you execute the following code SELECT APP_NAME() AS application_name You get the following result application_name ———————————————- Microsoft SQL Server Management Studio – Query This function can be effectively used to audit…

Interview Question of the Week #026 – 64 Bit Vs 32 Bit Confusion

June 28, 2015

Pinal Dave

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

SQL Server

I often see people getting lost between 64 bit and 32 bit operating systems and application conversation. There are plenty of individuals still today, not sure what is the difference between them as well what runs on what platform. Here are a few very simple questions related to Windows OS and SQL Server.

SQL SERVER – Tips working with Files inside SQL Server

June 26, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

When two SQL enthusiasts meet, often the conversation drifts to questioning each others understanding and implementation. Now, when two DBA’s meet it is always a great to see how the conversation goes because each carry a ton of baggage which can sometimes contradict too. One of the common rules of…

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

June 24, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

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…