Viewing 15 posts - 31 through 45 (of 48 total)
I have used a number of utilities for stress testing SQL for clients... one of the quickest tools to do some simple testing is SQLIOSim: http://support.microsoft.com/kb/231619
There are also a bunch...
March 3, 2009 at 12:58 am
Here is another useful script to monitor this. I can't claim credit, but it is incredibly similar to the other one posted here, formatted slightly different and with some...
March 3, 2009 at 12:44 am
The main thing you need to know is to execute the following from the mirror server when this happens...
ALTER DATABASE <database_name> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
Since that is a royal PITA when...
March 3, 2009 at 12:30 am
leonp (2/21/2009)
February 23, 2009 at 10:56 am
If these are sql logins and not windows logins you could create a job that executes the following t-sql at the disable time
ALTER LOGIN UserNameHere DISABLE
And then another job that...
February 21, 2009 at 12:53 am
If this is a standard sql job executing t-sql, you may want to convert this into a maintenance plan (this makes it easier to manage the backups), decide what your...
February 21, 2009 at 12:45 am
What operating system are you running? Is your workstation a member of an active directory domain? If so, is there a GPO being applied blocking the windows installer...
February 21, 2009 at 12:37 am
Why not export to a flat file (http://msdn.microsoft.com/en-us/library/ms141668(SQL.90).aspx) as delimited or fixed width? Those files would then be readable by Excel without any issue.
[edit]posted the sql 2008 link accidently,...
February 21, 2009 at 12:19 am
There has been a big debate about this among a number of engineers at my company, myself included and I think there are times when it is ok and times...
February 21, 2009 at 12:05 am
Ahmad, what is the numeric value on this line indicating?
job.Script 1203765415, sfileName
February 20, 2009 at 7:16 pm
I'm not 100% certain but you may be able to do the following...
exec Server2005.msdb.dbo.sp_send_dbmail
@profile_name = 'Sample',
@recipients='ABC@net.com',
@subject='FAILED JOBS REPORT',
...
February 20, 2009 at 7:10 pm
It sounds like you are doing this on a 32bit XP Installation so installing the 64bit version is not going to work. You may want to try and download...
February 20, 2009 at 3:03 pm
Actually good question because that syntax is not actually valid in sql 2008. you would need to use the following for sql 2008...
Insert Into dbo.employees (ID, FirstName, LastName, Age)
Values('1018','Neeraj',...
February 20, 2009 at 12:21 pm
This article using Hyper-V would be more interesting I think, although due to the changes in Windows 2008 clustering you might have a problem with the shared storage for the...
February 20, 2009 at 12:08 pm
Thank you Steve, that second link is the exact one I was looking for. It's now added to my Live Favorites so I dont lose it!
Thanks again!
February 20, 2009 at 11:48 am
Viewing 15 posts - 31 through 45 (of 48 total)