Viewing 15 posts - 3,946 through 3,960 (of 49,571 total)
You don't need to shrink the file. Once you've deleted the logging info, SQL will reuse the space in the data file.
December 24, 2015 at 1:09 pm
Ack, didn't notice that the 'not supported' list is for system database locations.
But still, you don't need to go to the extra effort of mapping a drive that the SQL...
December 24, 2015 at 8:37 am
SNAPSHOT is the row-versioning equivalent of SERIALIZABLE, so probably whatever requires the lock in SERIALIZABLE also requires it in case anyone's running SNAPSHOT and doing (probably) a mod to the...
December 24, 2015 at 2:52 am
They're very useful when writing complex queries. Write a basic query, turn it into a CTE, write the next query off that, etc. Easier debugging too, as at any point...
December 24, 2015 at 2:48 am
It's an optimisation, SQL can tell that you're updating a column to itself and hence doesn't take the locks. I can't remember what the transaction log entry looks like for...
December 23, 2015 at 11:23 am
johnwalker10 (12/22/2015)
Try DBCC CHECKDB with parameters REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS to fix the corruption of your database.
No! No! No! No! No! No! No!!!!!!!
Suggesting what is the absolute last resort, and can...
December 23, 2015 at 1:51 am
sri2015 (12/23/2015)
EXEC XP_CMDSHELL 'net use H: \\foldername1\foldername2\sharedfoldername3'EXEC XP_CMDSHELL 'Dir H:'
EXEC XP_CMDSHELL 'net use H: /delete'
Nope!
SQL does not support mapped drives for database files, just the //server/share format, as...
December 23, 2015 at 1:48 am
Larry Kruse (12/22/2015)
Other than just general tidiness, why would it be important to clean out those (apparently) stalled connections/sessions?
It's not.
Sleeping connections are doing nothing. Other than taking a couple...
December 23, 2015 at 1:46 am
itguy2015 (12/22/2015)
I prefer to have the cancel run to completion and have mydb on vm2 remain as it was before I started the restore.
You could leave it from now until...
December 23, 2015 at 1:43 am
anthony.green (12/23/2015)
The only thing I would suggest is to look at TDE (Transparent Data Encryption) https://msdn.microsoft.com/en-us/library/bb934049(v=sql.105).aspx
Which is an Enterprise edition feature.
With Standard edition, you'll need a 3rd party backup tool...
December 23, 2015 at 1:41 am
Oh that one. I saw it before it went off the rails and decided I didn't want to get involved.
Still, it's working so it can't be impossible... *angel*
December 22, 2015 at 12:28 pm
Narendra-274001 (12/22/2015)
How about the - Having millions and millions of rows in a single partition
Not by itself an indication for partitioning. Now, if you want to use fast swithing for...
December 22, 2015 at 12:10 pm
Eirikur Eiriksson (12/22/2015)
December 22, 2015 at 12:06 pm
I suggest you read this: http://www.sqlservercentral.com/articles/Administration/64582/
Then, once you've finished, read this: http://www.sqlservercentral.com/articles/books/94938/
December 22, 2015 at 11:56 am
December 22, 2015 at 6:19 am
Viewing 15 posts - 3,946 through 3,960 (of 49,571 total)