MOVING SYSTEM DATABASES
Below document provides information that can be used for moving system database. However this is not recommended for database installation...
2015-09-12
26,939 reads
Data Needed to Recover SQL server from a Host Crash
Am sure every DBA has once in his/her career come across a situation of recovering a database or an instance...
2015-09-12
301 reads
What happens when you execute a query
When a query is submitted to SQL server it goes through several processing steps. A proper understanding of these steps...
2015-09-12
4,894 reads
SQL Join Algorithms
SQL queries implement various joins when datasets are to be retrieved from one/multiple tables and merged on a certain criteria...
2015-09-12
4,345 reads
Outlier Detection with SQL Server, part 8: A T-SQL Hack for Mahalanobis Distance
By Steve Bolton
…………Longer code and substantial performance limitations were the prices we paid in return for greater sophistication with Cook’s...
2015-09-23 (first published: 2015-09-12)
3,645 reads
Argenis and Ryan
It’s the time of the year when PASS holds its annual elections for the board of directors. This year we...
2015-09-11
868 reads
Fall Means Election Season
While it’s not officially Fall yet, it is definitely Election Season. Elections for the PASS Board of Directors opens up...
2015-09-25 (first published: 2015-09-11)
868 reads
Extended Events – Event Anatomy
As a follow-up to the introduction to what an Event is, it makes sense to discuss the components of an event. What makes up an event? What is the...
2015-09-11
20 reads
Extended Events – Event Anatomy
So far in these brief discussions about Extended Events, I have covered several core concepts including a basic introduction into...
2015-09-11
623 reads
Work of art – the intra query parallelism deadlock graphs
Look at some of the graphs produced by the intra query parallelism deadlocks, below.
Bart Duncan explains this “phenomenon” (bug, rather)...
2015-09-10
1,385 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers