Analytic Functions – FIRST_VALUE / LAST_VALUE
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-15
4,017 reads
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-15
4,017 reads
The stupid, stupid Windows search (Start Menu > Search) doesn’t work on one of my computers (running WinXP Pro). Yes, I made...
2011-09-15
483 reads
I have to say, I only recently noticed this on a tool tip:
and this in the property sheet:
The bad news...
2011-09-15
1,666 reads
What is the difference between COUNT(*), COUNT(1) and COUNT(ColumnName)? A mystery that will never be known… ok that was a...
2011-09-15
13,135 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-09-14
580 reads
It was a normal Monday. I was going over some HA designs and planning the joys of setting up log...
2011-09-14
2,304 reads
I wanted to write this because lately I say “I don’t know” a couple times a day to my client/boss....
2011-09-14
622 reads
This is a technique I’m sure many people are already using in their environments. Instead of using the actual name...
2011-09-14
3,589 reads
With a late cancellation with one of our speakers a hole was opened on our speaker lineup. I reached out...
2011-09-14
422 reads
There's nothing more I love than free food and SQL Server, no joke. I take my free food and SQL...
2011-09-14
522 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
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