So, not good for general history/audit tables (which...

• This reply was modified 6 years, 4 months ago by Jeff Moden. Reason: Add the edit comment

Do you have any names that look like the following and, if so, what do you want to do with them?  Eliminate the periods and stop at the first space...

Thanks for feedback responses everyone and yes its better to work backwards from answer and possibly explain your code syntax logic. I just learning sql. Did not know what...

Of course, that recommendation also comes with the warning that if the hashbytes are different, then the rows are guaranteed to be different.  However (and you...

I beg to differ on the "As compared to the rebuild index operation, reorganize index is less resource-consuming operation" assertion.  That is not a clear-cut assertion either way.  From...

Hi Mala,

First of all, great article.  It can be used both as a great introduction to graph tables and to solve a fairly common problem.  Your order of revelation and...

I'll second Andrew's take on this.  Focusing on T-SQL until you've really learned the licks is the right thing to do and it will help you quite a bit when...

Yes sorry.... I have a tendency of assuming folks can read my mind.  What I want to do is to get the first 5 letters of the first name...

I don't think you can...

If the ultimate use for the CSV file will be to load into an Excel spreadsheet, you can also make a "Refreshable Spreadsheet" that calls a stored procedure to get...

That's certainly another viable option and it has kind of a user interface built in.

Yes, partially (although it almost never hurts to do so).  It may also be an indication that you have code to fix that might still blow through whatever memory you...

I think it's actually a much more valuable skill to learn when to NOT change.  I've seen a lot of so called "improvements" to things, especially in the world of...

It's not bad enough that some of us have problems with the likes of using the wrong kind of rounding or what have you.  SQL Server "helps" us make some...

On the subject of the tired adage of "Good/Fast/Cheap... Pick 2.", I end up saying to people that tell me that, "Ummmm... Ok... I thought you were a professional". 😉

There's...