When you setup the trace in SQLProfiler, be sure to include the TextData and HostName columns.  Then, on the Events Selection tab, click on the column name and setup a...

It became a "water cooler" thread very early in its existence.  😉  Most of us...

To me, encrypting it is always in scope.  I just got yet another hack-attack alert about 6 million peoples' data being stolen including SSNs.  Seems like I get one every...

Still if I am going to use code to process data manipulation with a need for speed I am going to use a compiled language (C, C++, Java, etc...)...

Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".

How about the rest of you good folks... did anyone else...

Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".

How about the rest of you good folks... did anyone else...

SQL would be my first choice for cleaning data, while it's a powerful tool for querying and cleaning data, it may not be the best choice for performing complex...

Hi there! It sounds like you want to create league standings based on game data and team data in different seasons. Here's what you can do:

First, you'll need to...

Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".

How about the rest of you good folks... did anyone else have a...

Thanks, Eirikur.  I appreciate...

Shifting gears a bit...

I ran across an article that had the following statement in it...

"Learning SQL helps us to communicate with databases, but when it comes to cleaning, manipulating,...

@Below86 ,

Looking at what you said, I can really sympathize.  To be sure, my comments were based on people that were actually hired to work with T-SQL day in and...

The appropriate method to shrink a log file for a database in bulk/full recovery model is:

1. put the database in simple mode, full backup

2. shrink the log file,

3. put...

Hey Jeffrey thanks for chiming in.

Let me clarify what’s happening. There is a delete query and an insert query wrapped in a Begin Commit/Rollback Tran. Some of the data...

Yep... I got that and agree.

Again, there...