Viewing 15 posts - 35,851 through 35,865 (of 39,804 total)
If I remember correctly, a table is only on one file. Perhaps there is a table(s) that is growing larger on the first filegroup and so this file grows disproportionately?
Are...
October 2, 2003 at 3:43 pm
If disk space is an issue, and you can afford a little time, you might also run a differential backup once or twice a day and delete all log files...
October 2, 2003 at 3:41 pm
I've used all three and have tended to favor white boards, usually with everyone present spending a few minutes at the end trying to copy on their notepad what they...
October 2, 2003 at 3:29 pm
Isn't camelcase uniqueNameForObject?
In any case, I completely agree. Spaces are a pain!!!! especially when scripting.
I'd expand this to include stupid folder names as well (#$%#^#$%$# Program Files folder)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
October 1, 2003 at 4:39 pm
Yes it is running on his workstation.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 1, 2003 at 4:37 pm
contact Andy Warren for specs, but basically, basic HTML.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 1, 2003 at 4:36 pm
Two is correct.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 1, 2003 at 4:36 pm
For the backup, you need to setup an operator and SQL Mail and in the job properties, you can notify the operator when the job fails.
For the logins, you can...
October 1, 2003 at 11:03 am
I would use Phil's suggestion though you can build a batch file that calls DTSRUN with a a parameter for the package. The package could be on either the server...
October 1, 2003 at 10:58 am
Are you trying to determine what eats up the time for a query to return results to the client?
You've got IO, bandwidth on the network, rendering time on the client.
Steve...
October 1, 2003 at 10:56 am
I agree. PSS can help, but will likely point to hardware as the problem. These kinds of things can be very, very difficult to track down and could easily be...
October 1, 2003 at 10:54 am
I think you might want UTC date for the comparisons if you are getting data from 2 different time zones. But yes the time is calculated on the server.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
October 1, 2003 at 10:53 am
BKelley has some good advice somewhere. Not sure if he wrote an article or if it is in an ebook he did, might check with him. Or send him an...
September 30, 2003 at 9:40 am
no way I know of. Better to write some check in there, perhaps add a table to some other database and mark this before a restore and unmark it after....
September 29, 2003 at 2:47 pm
Viewing 15 posts - 35,851 through 35,865 (of 39,804 total)