Viewing 15 posts - 23,836 through 23,850 (of 39,944 total)
Lynn Pettis (5/22/2009)
I like watching professional soccer. You rarely see the coaches getting angry on the touchline with the officials (not saying the don't).
You rarely see anything happen in...
May 22, 2009 at 10:18 am
John,
Thanks, and there are a few people here in scouts. Grant Fritchey leads a Cub Scout group. Congratulations to you on your Eagle as well. Something to be very proud...
May 22, 2009 at 10:10 am
I don't think it's more or less efficient storing the value in a table.
Calculating it is a function call, no I/O, minimal CPU to perform.
The query writing to a table...
May 22, 2009 at 9:59 am
The only way I know of for the plan in 2000 is a screen shot, and if it doesn't fit on one, multiple ones.
The text plans are harder to read,...
May 22, 2009 at 9:51 am
Grant Fritchey (5/22/2009)
May 22, 2009 at 9:50 am
You would have to go into more detail. not just the script, but how does the file get there? Is it copied? Perhaps it's not completely copied when the procedure...
May 21, 2009 at 9:42 pm
I've taken an opposite tact. Often I've just tracked the file sizes of backups.
Either way works, just be consistent.
May 21, 2009 at 5:58 pm
Didn't think of that, Greg, and it's not bad. It is maintenance if you change the job, though you could abstract things with stored procedures.
Adding/removing a day means just adding...
May 21, 2009 at 5:37 pm
It fails in some places, with some keywords, but you are right. For the most part, SQL Server can figure it out.
However, it also messes up color coding, and confuses...
May 21, 2009 at 5:32 pm
So the access used to work with people being members of Group1?
Are you sure it wasn't through some other method that got revoked?
I'm not enough of an AD guru to...
May 21, 2009 at 5:28 pm
Jeffrey is correct, it isn't stored.
the closest thing is to check the backup file sizes. There is a size stored in msdb.dbo.backupset, which gives you an "idea" of data size....
May 21, 2009 at 5:26 pm
Two simple ways from me. There might be more elegant, but off the top of my head.
1. control access to saving by removing insert for users on the tables, use...
May 21, 2009 at 5:24 pm
That is interesting. Thanks for the link.
May 21, 2009 at 5:14 pm
Do any of the items above matter to you? Limits on SQL Server? Windows only?
If not, what do you have more expertise in from a development standpoint?
May 21, 2009 at 5:11 pm
Viewing 15 posts - 23,836 through 23,850 (of 39,944 total)