Viewing 15 posts - 35,821 through 35,835 (of 39,771 total)
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
When you restore the full, you have to specify the "with norecovery" or with "standby" options. Then you can load t-logs. Need to be sure you do not complete recoery...
September 29, 2003 at 2:42 pm
create procedure spTest
@txt text
as
select @txt
go
Try this for the variable of the OpenXML part.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 29, 2003 at 2:41 pm
Thanks for the note. I haven't really worked with Site Server.
I'd like to see some of this in the core product, or as an option for SQL Server itself. Images,...
September 29, 2003 at 1:45 pm
Viewing 15 posts - 35,821 through 35,835 (of 39,771 total)