Windows Cluster : Understanding the Quorum settings
In my earlier post, I have explained about the windows cluster and how Sql server works on cluster environment. In...
2012-07-18
3,999 reads
SQL Server: Instant Deadlock Alert Using WMI in Your Mailbox
In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...
2012-07-17 (first published: 2012-07-16)
5,608 reads
SQL SERVER:How Can I Get Notification Alert When Fail Over Happened ?
It was long time I was searching for simple solution to get notification alert in my inbox when ever fail...
2012-07-16 (first published: 2012-07-05)
5,068 reads
SQL Server: Instant Blocking Alert Using WMI in Your Mailbox
As a DBA, it is important for all of us to get real time alert on various issues in our...
2012-07-13
6,746 reads
SQL SERVER : SQL Server Scheduler
While troubleshooting the performance issues of SQL server, you might have seen the sessions are in different state like SUSPENDED,RUNNING,RUNNABLE etc....
2012-07-12
8,737 reads
SQL SERVER : The Scene Behind NOLOCK
I have heard many time people talking about the NOLOCK hint. Some of them says it improves the performance and...
2012-07-12 (first published: 2012-07-04)
6,753 reads
SQL Server : Parameter Sniffing
Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....
2012-06-29 (first published: 2012-06-25)
8,988 reads
How Local Variable or Optimize for Unknown Resolve Parameter Sniffing
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible...
2012-06-27
3,428 reads
SQL Server : Moving System, resource and User Databases to New SAN disk
In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive...
2012-06-18 (first published: 2012-06-12)
4,232 reads
Connection Pooling :At a Glance
What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...
2012-06-15
8,101 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers