T-SQL Tuesday 14: Resolutions #TSQL2sDay
Time for the first T-SQL Tuesday of 2011. This month Jen McCown (Blog | @midnightdba) is hosting the event. The topic...
2011-01-11
556 reads
Time for the first T-SQL Tuesday of 2011. This month Jen McCown (Blog | @midnightdba) is hosting the event. The topic...
2011-01-11
556 reads
Is it just me or has the community done the whole “What are my goals for this year” thing to...
2011-01-11
643 reads
Sounds like a good action adventure movie. The theme this month on TSQL Tuesday, thanks to our host, Jen McCown...
2011-01-11
996 reads
In my invitation to T-SQL Tuesday #014, I picked the topic “Resolutions”, clearly to play on the new year. The...
2011-01-11
745 reads
Last week Donald
Farmer announced that he was leaving his long-time position as Microsoft’s lead
BI technology evangelist for QlikTech, a small...
2011-01-11
699 reads
A few months back, well before the 31 Days of SSIS started, I had been playing with the Pivot Transformation. ...
2011-01-10
1,170 reads
The recently resurrected DevTeach/SQLTeach event will be held May 31 through June 2, 2011 in Montreal, Canada at the Montreal...
2011-01-10
645 reads
Most technical professionals don’t seem to enjoy writing and maintaining documentation for their databases. I know that documentation falls pretty...
2011-01-10
3,317 reads
In the last months I had done a lot of performance tuning workshops, and there is
almost the same question: How...
2011-01-10
2,307 reads
I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small...
2011-01-10
1,377 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers