ORDER BY Clause with clustered index
One thing that I have seen repeatedly is that (too) many people believe that if you have a clustered index...
2011-08-20
1,982 reads
Win a Ticket to the “Advanced Programming” Course
We are opening another class of the “Advanced Programming in SQL Server” course on 28/08. You can find all the...
2011-08-20
473 reads
JAX Code Camp 2011
For the past 7 years, Bayer White and other Jacksonville .Net leaders have put on great Code Camps for .Net...
2011-08-19
1,012 reads
SQL Server – "Denali" – PERCENT_RANK() Analytic Function
PERCENT_RANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENT_RANK() ranks rows between...
2011-08-19
1,062 reads
SQL Server 2008 SP2 cumulative update 9
AdvertisementsSQL Server 2008 latest cumulative updates 9 build 10.50.1804 available now. You may download and test itCumulative Update 9 for...
2011-08-19
1,027 reads
Methods for populating a data warehouse
Source tables change over time. A data mart or data warehouse that is based on those tables needs to reflect these...
2011-08-19
4,960 reads
Bitwise Operations
Some time ago, I wrote an introductory post about bitwise operations in SQL Server. I had fully intended on writing a follow-up to that. Alas the opportunity has passed...
2011-08-19
27 reads
Bitwise Operations
Some time ago, I wrote an introductory post about bitwise operations in SQL Server. I had fully intended on writing...
2011-08-19
1,603 reads
Re-blog – August 12-August 18
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-08-19
757 reads
Attach database without log file and rename database
Assuming the database was detached successfully , this t-sql code will attach a mdf file without a log file . It will also...
2011-08-19
1,335 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers