Live Query Statistics
The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option...
2015-08-27 (first published: 2015-08-19)
2,470 reads
The objective of this post is to introduce the new feature in SQL Server 2016 called Live Query Statistics. This option...
2015-08-27 (first published: 2015-08-19)
2,470 reads
HI all
Today received the mail from RED-GATE team on this topic “How to find CPU intensive queries” . It is an...
2015-08-24 (first published: 2015-08-17)
10,202 reads
HI ALL
In One Of the Group the question was asked that How to list all the Servers in which SQL...
2015-07-30
17,420 reads
Microsoft has announced that The SQL Server 2016 Upgrade Advisor Preview and SQL Server 2016 Community Technology Preview (CTP) 2.2 are...
2015-07-23
1,094 reads
COLUMNSTORE INDEX
How data is stored in traditional way
For physical storage of a table, its rows are divided into a...
2015-07-11
2,520 reads
How to Grant limited permissions to create views in another schema?
In SQL Server 2005 and 2008R2 you can grant permissions...
2015-07-08 (first published: 2015-07-01)
3,159 reads
Last week as part of job I had to migrate the Databases and Reporting Service of SQL server 2005 To...
2015-06-22 (first published: 2015-06-11)
3,188 reads
In Previous post we have seen the new features of SQL server 2016 in short and had a brief discussion...
2015-06-11 (first published: 2015-06-08)
4,953 reads
At this year’s inaugural Ignite Conference in held in Chicago Microsoft announced that the next release of SQL Server, previously...
2015-06-03
1,138 reads
Yes after its initial release and pull out Microsoft has again made the Service pack 1 for SQL SERVER 2014...
2015-05-20
453 reads
By Steve Jones
mcfeely – adj. inexplicably moved by predictable and well-worn sentiments, even if they are...
I posted on Terraform and Azure SQL last year but wanted to see what...
By Kevin3NF
As a SQL DBA, what do you do when a vendor application has performance...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
HI All, can any one reply on this when primary is down and not...
Comments posted to this topic are about the item The On-Call Load
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers