Viewing 15 posts - 16 through 30 (of 77 total)
OK, well the first problem is that with the quiesce option turned off the snapshots are useless for backups as SQL hasn't flushed the buffer and the transaction log and...
December 17, 2013 at 12:37 pm
Are you using RDMs or normal VMDKs? If you are using VMDKs then you'll want to turn the quiesce option back on. If you are using RDMs then...
December 17, 2013 at 11:03 am
I've got good news and bad news. The good news is that you already know the command to use. The bad news is that you have a lot of typing...
November 2, 2013 at 7:56 am
Probably as it would get databases off of the instance. The ability to do that would of course depend on the application design.
August 23, 2013 at 10:42 am
If you've got that many databases and that many are inactive you'll want to set the inactive ones offline. If they are online when the SQL Server starts then it...
August 22, 2013 at 1:38 pm
That's going to be well outside anything that Microsoft has tested (http://technet.microsoft.com/en-us/library/ff878487.aspx) and probably wouldn't be supported by Microsoft. And given the limited number of threads for...
August 22, 2013 at 1:27 pm
That should have said increase in physical io. Apparently autocorrect made a mess of my post.
July 15, 2012 at 9:57 pm
Yes, you'll see an increase not the physical disk io, provided that your working set is larger than the amount of memory you have allocated to SQL Server.
July 15, 2012 at 8:36 am
Have you looked at database firewall products. Products like "SecureSphere Database Firewall" will monitor all the commands which are sent to the SQL Server. Is this what you...
April 4, 2012 at 5:55 pm
Ivan Mohapatra (1/9/2012)
As i Have a task to find 9 digit value in all column of all table in a DB or All DB in SQL server 2005.
SO...
January 9, 2012 at 1:10 am
The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: XXX.XX.XX.XX]
You'll want to do what...
November 7, 2011 at 5:59 pm
Look for my article in SQL Server Magazine from about 2 years ago. I did a full walk through on the process.
Denny
November 2, 2011 at 2:19 pm
After starting the job you will want to run a loop which calls sp_help_job and passing in the job name. This will tell you if the job is running...
September 14, 2011 at 8:46 pm
No. BCP will work with relative paths, as long as you are running the command in the correct path.
September 13, 2011 at 4:52 pm
bcp DimProducts in Documents\DimProducts.txt -T -c
This is the error message I am now getting:
SQLState = $0002, NativeError = 208
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server] Invalid obeject name 'DimProducts'.
OK,...
September 13, 2011 at 4:45 pm
Viewing 15 posts - 16 through 30 (of 77 total)