Viewing 15 posts - 5,071 through 5,085 (of 14,953 total)
I find maintenance plan tasks to be a good stopgap till you can get something "real" in place. They're very, very useful for new/accidental/incidental DBAs, but too limited compared...
February 8, 2011 at 9:27 am
Ferguson (2/8/2011)
Jack Corbett (2/8/2011)
I think that you should almost always include "or equivalent experience" when...
February 8, 2011 at 9:07 am
On the flow from source to destination (the arrow in the package designer), you can right-click and set a data view on the state of the data at that point....
February 8, 2011 at 8:44 am
Won't get you what you need on this point, so far as I know.
February 8, 2011 at 8:38 am
Makes sense.
I interviewed at a company once, where they tested their backup generator every month. And that used up all the fuel in it, so when they actually needed...
February 8, 2011 at 8:37 am
Lowell (2/8/2011)
doh i didn't even think about if there were any math functions in the bodies; good catch; i'm not sure on the commented comments...
Commented-comments are an edge case and...
February 8, 2011 at 8:31 am
The easiest way to do it is to check a range.
Where CreatedOn >= '2011-02-03' and CreatedOn < '2011-02-04'
There are other ways to do it, but this one almost always works...
February 8, 2011 at 8:24 am
You'll want to set up a script, using dynamic SQL, that will step through all databases on a server and do a basic health-checkup. Then copy that and a...
February 8, 2011 at 8:20 am
There are edge cases where Lowell's solution will return a false positive. For example, a commented-out-end-comment.
/* This comment has been
--*/modified
by devs who weren't paying attention*/
Reversing the sequence on...
February 8, 2011 at 8:15 am
I think the latest version of the job posting is clear enough and presented well enough.
Other than the degree requirement, it's one I would apply for if I were looking....
February 8, 2011 at 7:57 am
That kind of complex pattern matching is going to be best done through regex functions. That means CLR, since that's MUCH better at regex than T-SQL.
Once you've built the...
February 8, 2011 at 7:28 am
Here's an article on hierarchies. It includes a link to Joe's data on the subject (which is must-read for any DBA).
February 8, 2011 at 7:19 am
An inline sub-query in the Select clause would work just as well as an explicit join, probably. Has the advantage/liability that it will give an error if there are...
February 8, 2011 at 7:16 am
A maintenance plan can have a "clean up history" step. That's the most usual cause of data in that table going away. Check the scheduled jobs in SQL...
February 8, 2011 at 7:11 am
Viewing 15 posts - 5,071 through 5,085 (of 14,953 total)