Forum Replies Created
Viewing 15 posts - 736 through 750 (of 7,466 total)
-
Reply To: Entire Row to be Unique in the whole Table...
As already stated, a unique index or a unique constraint are your options
ref:...
-
Reply To: sql server and when adding files and capping space
Even when adding a new file to a filegroup, SQLServer will not balance the content of that filegroup to all files of that filegroup just like that.
If you would want...
-
Reply To: Reclaim disk space after truncate
You cannot reclaim disk space without shrinking the database, except for tempdb which is being reset to its original size after stop/start of the instance.
Alternative is to create a new...
-
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?
Indeed, Jeff.
Those were the timing for the migration of the tables.
I'm still working to see if the applications actually have performance gains too.
Gut feeling says it should, but we'll only...
-
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?
I prepared all filegroups and files and preallocated the needed space.
These are the results of my test on my test server ( old + slow spindles )
-
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?
wow, Thank you Jeff, for your tests and posting the results.
As always, YMMV, so only own situation tests will provide a good insight.
Hoping such tests confirm the handed numbers and...
-
Reply To: DBMail
- create a test job and send some mails to yourself.
- Send some emails with your own email address in BCC to find out if they actually arrive.
- As it...
-
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?
They are still image and text data types (legacy industrial tech "we will not change it for you" salesperson ). Out of row by default if I'm correct., but indeed,...
-
Reply To: Advantage of having multiple files is a filegroup designated for LOBs ?
That's indeed what I've been thinking, but I have not that much experience when it comes to storing LOBs ( up to 1GB ) in the database, so I've been...
-
Reply To: Deadlock in SQL
also keep in mind , if you are able to extract the deadlock xml (copy/past into a .xdl file), SentryOne PlanExplorer has a nice "replay" feature that shows the sequence...
-
Reply To: Generate script
How about
/* generate DDL */
exec sp_msforeachdb '
Select ''
USE [?]
GO
CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification-DatabaseA]
FOR SERVER AUDIT [ServerAuditName]
ADD (INSERT ON DATABASE::[?] BY [dbo]),
ADD (SELECT ON DATABASE::[?] BY [dbo]),
ADD (DELETE... -
Reply To: help with SQL script
What's the condition on which you determine which hour to be returned ?
-
Reply To: Migrate On-prem DB
I just encountered this picture which also applies to our line of duty ...
-
Reply To: SP causing blocking
Some monitoring softwares will show blocking in the engine and may get you on track detangling such issues.
If you think (b)locking is the issue, you may even want to try...
-
Reply To: Enabling indexes
Keep your data catalog correct and disable an index if you want to re-enable it later!
This way, persons investigating "troubles" will know someone performed this action on purpose ( as...
Viewing 15 posts - 736 through 750 (of 7,466 total)