Rows or Range, What’s the difference ?
With the release of Denali CTP3 came an extension of the over clause to allow for a sliding window of...
2011-09-22
2,300 reads
With the release of Denali CTP3 came an extension of the over clause to allow for a sliding window of...
2011-09-22
2,300 reads
In case you didn't know SQLBits 9 ,”Query across the Mersey”, is taking place in Liverpool from September 21st to...
2011-08-31
1,555 reads
Over the past few weeks, I’ve been training developers in what they really need to know about SQL Server to...
2011-08-01
1,331 reads
In Denali CTP3, we have a new of new functions to play with. For this post, im going to focus...
2011-07-19
790 reads
In my last blog I showed how persisted data may not be used if you have used the base data...
2011-06-20
530 reads
Not that you would know it from the page below, but Itzik Ben-Gan is back in London to do a...
2011-06-17
1,276 reads
Working at a client site, that in itself is good to say, I ran into a set of circumstances that...
2011-06-13
621 reads
Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...
2011-06-06
2,172 reads
At the Kent user group we have two upcoming events. Both are to be held at F-Keys Training suite http://f-keys.co.uk/...
2011-06-05
636 reads
Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay. Its a true pleasure to...
2011-05-29
1,330 reads
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers