Viewing 15 posts - 166 through 180 (of 245 total)
Two things:
- Maybe my browser rendered the page incorrectly, but I had a hard time reading it as it was all black text on a dark grey background.
- The author...
October 21, 2013 at 6:40 am
My wife is generally the "just make it work" kind, also, but a number of years ago she was working in a local government office and decided to create a...
October 17, 2013 at 1:04 pm
I'm pretty much the same, with the addition of downloading and installing SQL Server Express (free) or purchasing the Sql Server Developer version (available for around $60 or so) on...
October 17, 2013 at 12:53 pm
Koen Verbeeck (10/16/2013)
In a few weeks I'll attend an analytics seminar where Kimball will deliver the keynotes.
Might...
October 17, 2013 at 12:32 pm
I've run into this when there is an extra CR/LF at the end of the file: In other words, your last actual line of data has a CR/LF and there...
October 3, 2013 at 5:48 am
PiMané (9/30/2013)
Why doesn't a RAISERROR inside an AFTER trigger "break" the transaction? Is there any flag or SET option to do it?
The update is committed even with the error raised...
October 2, 2013 at 5:38 am
Might I suggest Rodney Landrum's SQL Tacklebox located here:
http://www.red-gate.com/community/books/sql-server-tacklebox
He includes a boatload of scripts - downloadable as a zip file - for documenting and monitoring SQL Server instances using T-SQL...
October 1, 2013 at 5:17 am
Yuck.
You can also import each entire line into a table then use some kind of multi-pass replace() construct or a REGEX via CLR to change out the delimiters.
September 27, 2013 at 6:54 am
paul.j.kemna (9/27/2013)
Isn't SET DATEFIRST a sever wide setting?
Nope. Only affects the session. I've been developing code to create and update a master calendar table for our organization so...
September 27, 2013 at 6:23 am
Stewart "Arturius" Campbell (9/20/2013)
In case of doubt, refer to Ralph Kimball's book, "The Data Warehouse Toolkit, 2nd Edition"
Just FYI - Kimball is up to third edition now. I haven't...
September 27, 2013 at 5:52 am
You also want to check your anti-virus software and firewalls and be sure DatabaseMail is permitted.
September 25, 2013 at 8:00 am
I've mentioned this example before, but it's completely appropos:
My boss used to work for a call center. Every so often the entire system would crash for no apparent reason....
September 25, 2013 at 6:44 am
Koen Verbeeck (9/18/2013)
Personally I like printed books the most. Nothing beats the actual touch and feel of an actual book. (and you can kill flies with it!)
Well, you CAN kill...
September 19, 2013 at 10:52 am
Did someone mention backups and restores?
Having just finished restoring a blown server which housed our SQL Server instance :crazy:, I'll put the exclamation point on backups/restores.
To wit -------> !
September 19, 2013 at 10:45 am
I remember a couple decades back reading about MCSEs and so forth, how Microsoft billed them as a way for professionals with demonstrated experience to document that and were intended...
September 10, 2013 at 6:06 am
Viewing 15 posts - 166 through 180 (of 245 total)