Viewing 15 posts - 55,081 through 55,095 (of 59,078 total)
That helps, but better to have the partitions on different physical disks for real performance gains...
September 11, 2007 at 8:08 pm
No need for a trigger... You can revoke permissions from individual users by column in a table or view. Lookup REVOKE in Books Online for the full syntax.... but here's a...
September 11, 2007 at 7:34 pm
It wasn't negative!!! It was friendly advise that you're probably commiting some form of SQL suicide by needing to do this!!! ![]()
There's only one...
September 11, 2007 at 7:19 pm
Is it a bug or did the boys in Redmond just decide to change a default like they did with the CONCATENATE NULL YIELDS NULL setting?
September 11, 2007 at 7:14 pm
The "system" creates them... As you found out, it only creates them when the first instance is needed whether created by the backup code or use of an IDE. Best...
September 11, 2007 at 7:06 pm
Won't have poor performance if it's for multi-row batches... on busy systems, most batch procs will probably need to recompile due to data changes in as little as 5 minutes. GUI code is another...
September 11, 2007 at 7:02 pm
I'm thinking that your table is a bit denormalized... it should be like this...
EventID Fighter 1 5 1 10 2 ...
September 11, 2007 at 6:53 pm
That's a whole lot different than what you asked... but somethin similar to what I posted will still work. Just set some variables in the process. Have you read about...
September 11, 2007 at 6:00 pm
Understood... but you have no criteria for the table... that makes a cross-join.
September 11, 2007 at 5:55 pm
C'mon Zach... folks helped you out... the least you could do is post your solution ![]()
September 11, 2007 at 5:52 pm
Lookup "IF" in Books Online ("Transact-SQL HELP" in Query Analyzer) to find more about the following example (also from Books Online)...
IF (@ErrorSaveVariable <> 0)BEGIN PRINT 'Errors encountered, rolling...
September 11, 2007 at 7:27 am
No, I understood that... but typically there is some unique key (column or combination of columns) other than the GUID that would identify the unique row. Need that info to do...
September 11, 2007 at 7:20 am
Heh... if that's what he meant by decimal... Me? Guess it's obvious that I don't normally do those kinds of conversions, huh? ![]()
September 10, 2007 at 9:36 pm
But, doing it that way, it can't be turned back into an IP address, can it? And, theoretically, couldn't there be dupes that way? After all, the OP did say...
September 10, 2007 at 9:34 pm
Viewing 15 posts - 55,081 through 55,095 (of 59,078 total)