T-SQL Tuesday #024: Prox ‘n’ Funx
I find myself just now sitting down to write this as the deadline for TSQL Tuesday 24 fast approaches. Fortunately...
2011-11-08
655 reads
Jason Brimhall
T-SQL Tuesday #024: Prox ‘n’ Funx
Functions are very handy. They can also prove to be the cause of poor performance (such as was the case with that string splitter). When used appropriately, you can...
2011-11-08
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time will warp on us. The Las Vegas user group...
2011-11-07
SSSOLV November 2011 Meeting
Another month, another meeting. Time really is flying. And now with more Holidays fast approaching, I am sure that time...
2011-11-07
568 reads
We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time...
2011-11-07
667 reads
We are Family
It has been a while since I last wrote something for a meme monday. This month is a perfect time to jump back in the deep end. If you...
2011-11-07
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations...
2011-11-03
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that...
2011-11-03
1,261 reads
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are...
2011-11-01
726 reads
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are a few tools at your disposal to look up...
2011-11-01
4 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers