SQL Server Diagnostic Information Queries for July 2013
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-07-09
1,148 reads
Blog Posts
SQL Server: Part 4 : All About SQL Server Statistics : Auto Update Statistics Threshold - Importance of Manual statistics maintenance
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we...
2013-07-09 (first published: 2013-07-02)
4,936 reads
SQL Server: Part 5 : All About SQL Server Statistics : How to Detect outdated Statistics ?
In the last post, we have discussed about the auto update statistics threshold and concluded that auto updated statistics threshold are good enough to get optimal performance in some workload. In...
2013-07-09
30 reads
T-SQL Tuesday #44 - Second Chances
So, it’s Tuesday and its that time again for T-SQL Tuesday. We’re at the 44th entry which means it’s been...
2013-07-09
1,833 reads
T-SQL Tuesday #44 How to Take Down Prod in 30 Seconds
Hello Dear Reader! Welcome to my blog on T-SQL Tuesday #44 Second Chances. I’m hosting this month, and we are...
2013-07-09
1,700 reads
T-SQL Tuesday #44: The second chance
This month’s T-SQL Tuesday is hosted by Bradly Ball (blog | twitter) and the topic is second chances. The idea is...
2013-07-09
638 reads
T-SQL Tuesday #44–Second Chances
It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate,...
2013-07-09
1,080 reads
We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced
Power BI: a new suite of Business Intelligence tools Over the past few months, teams at Microsoft have made several...
2013-07-09
724 reads
In Memory OLTP with SQL Server 2014
SQL Server 2014 CTP is available for download and evaluation and it contains a couple of exciting performance enhancements. One...
2013-07-08
2,536 reads
Last Weeks Top “Reading” Links #40
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-08
1,181 reads
Blogs
SQL Server Journey Part 2: Modern Era (2017 – 2026) – AI/Cloud First
By Vinay Thakur
Following up on my Part 1 baseline, the journey from 2017 onward changed how...
Google Moves Up Post-Quantum Cryptography Timeline
By Brian Kelley
In cryptography, the RSA and ECC algorithms which we use primarily for asymmetric cryptography...
The Book of Redgate: No Politics
By Steve Jones
In today’s world, this might mean something different, but in 2010, we had this...
Forums
An Unusual Identity
Comments posted to this topic are about the item An Unusual Identity
Dancing Robot Goes Rogue
Comments posted to this topic are about the item Dancing Robot Goes Rogue
advice as i migrate my winscp based ssis pkg to our prod server
Hi , i installed winscp on my pc, added it to GAC thru vs...
Question of the Day
An Unusual Identity
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers