Viewing 15 posts - 3,946 through 3,960 (of 49,552 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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*
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2015 at 12:10 pm
Eirikur Eiriksson (12/22/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2015 at 11:56 am
Yes.
https://msdn.microsoft.com/en-us/library/hh759341.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 22, 2015 at 6:19 am
Viewing 15 posts - 3,946 through 3,960 (of 49,552 total)