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,646 reads
SQLSERVERSdba
How to find CPU intensive queries ?
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,403 reads
List Out All the SQL servers In domain
HI ALL
In One Of the Group the question was asked that How to list all the Servers in which SQL...
2015-07-30
18,017 reads
SQL server 2016 CTP 2.2
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,097 reads
COLUMNSTORE INDEX… DEMO
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,533 reads
How to Grant limited permissions to create views in another schema?
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,254 reads
SQL SERVER REPORTING SERVICE MIGRATION
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,202 reads
SQL Server 2016 features to look for -2
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,962 reads
SQL Server 2016 features to look for -1
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,146 reads
SQL server 2014 Service Pack is available (AGAIN ) !!!!!!!!
Yes after its initial release and pull out Microsoft has again made the Service pack 1 for SQL SERVER 2014...
2015-05-20
467 reads
Blogs
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
SELECT *
SELECT * feels convenient, but in SQL Server it bloats I/O, burns network bandwidth,...
Forums
Extract sql data in psh
# Load ImportExcel module Import-Module ImportExcel -ErrorAction Stop # File paths $outFile = "C:\Reports\SQLReport.xlsx"...
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers