Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions...
2015-03-26 (first published: 2015-03-19)
6,315 reads
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You...
2015-03-26
646 reads
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You...
2015-03-26
269 reads
I have a customer who is having a problem with a load. He is getting a fair number of bad...
2015-03-25
1,105 reads
Two weeks ago I attended SQLBits in London. This is probably the biggest SQL Server conference in Europe, and this...
2015-03-25
615 reads
Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in...
2015-03-25 (first published: 2015-03-16)
7,767 reads
How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be...
2015-03-25
779 reads
Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as...
2015-03-25
618 reads
I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...
2015-03-25
312 reads
After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:
PASS Italian Virtual Chapter, April 14. I’ll demonstrate...
2015-03-24
541 reads
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers