2014-06-30
2 reads
2014-06-12
3 reads
2014-06-10
1 reads
2014-01-08
4 reads
2014-01-03
9 resources not to be Skeptic about Big Data
2 years ago I posted “16 papers and original articles on Big Data” It’s now time to review and...
2013-06-01
6 reads
SQL Server 2012: Indirect Checkpoint (Target Recovery Time), get the real scoop
SQL Server 2012 brings a new feature called Indirect Checkpoint. You can read more about it here: http://msdn.microsoft.com/en-us/library/ms189573.aspx. With Indirect Checkpoint, you get smaller and too many I/Os Checkpoint...
2013-03-19
10 reads
The end of the Internet, data and the PC
The Big Data revolution will be more important than the PC or the Internet. While there were many...
2013-03-04
3 reads
2012-10-13
3 reads
2012-10-05
1 reads
Blogs
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Eliminate a function by writing out the code is now throwing an error
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
SQL Server Migration - Redirecting Old Instance Connections to New AG Listener
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers