Viewing 15 posts - 136 through 150 (of 211 total)
Lowell (6/14/2011)
One Procedure To Rule Them All? Lord Of The Rings Style?(img cut for brevity)
<Standing ovation/>
Saved.
June 14, 2011 at 10:06 am
Agreed, that's an excellent example to demonstrate the reasoning behind "one routine for one task".
June 14, 2011 at 9:34 am
The instead of insert won't have the identity values, though, since the "inserted" table will return zeros for the identity column. You'd have to turn identity_insert on and generate your...
June 14, 2011 at 3:04 am
GilaMonster (6/14/2011)
Craig Farrell (6/14/2011)
I personally like bit fields, and bitmap fields.Bits yes, bitmaps no.
Technically they violate 1st normal form.
Not according to Chris Date 😛
Other than that I agree.
June 14, 2011 at 12:10 am
In my opinion it's not a good idea (for reasons of permissions, datatyping, and maintenance) unless your manager has some specific argument for wanting to do it in your situation....
June 13, 2011 at 10:39 pm
The advantage of using a bit is that it constrains the domain of available values to those that make sense for a true/false operation (particularly if defined as not null),...
June 13, 2011 at 10:34 pm
Each operation essentially "undoes" the other in terms of logical fragmentation.
Shrinking the database takes pages from the end first, and moves them to free space in the front. Rebuilding an...
June 13, 2011 at 8:35 pm
george sibbald (6/13/2011)
there are sub cmdhell (sic) xps that do these sort of tasks. Not as easy to use I grant you but they exist (xp_delete_file, xp_fileexist etc)
It's true, there...
June 13, 2011 at 6:41 pm
Just some additional info: a server side trace is not the same as running profiler on the server. Look up "server side trace" in google (you'll probably get directed to...
June 13, 2011 at 9:31 am
Mine look something like this:
select case
when 1 = 1...
June 13, 2011 at 9:03 am
I just wrote a set of procedures to assist with backup/copy/restore. They're built to work with Ola Hallengren's backup and maintenance procedures, taking care of copying the backups and doing...
June 13, 2011 at 8:14 am
I don't really understand your question, but be very careful using words like "array" and "loop through" That's procedural talk, my friend. We're declarative around here 🙂
June 13, 2011 at 8:06 am
Do not use the proprietary UPDATE.. FROM.. syntax; it has cardinality problems and will not port. But it looks weird to me; why do you want to set every...
June 13, 2011 at 8:01 am
My gut reaction is that this is an ugly solution (particularly bringing XML in, ugh... XML...).
Does your manager have a particular reason for wanting to do it this way?
One...
June 13, 2011 at 7:54 am
There are many solutions. Here's a fun one:
Since you have specified that you can only have two students (and with the reasonable assumption that each student ID is unique to...
June 13, 2011 at 7:49 am
Viewing 15 posts - 136 through 150 (of 211 total)