Viewing 15 posts - 346 through 360 (of 476 total)
Wurstsalat (9/17/2015)
but i dont know how to do this
Have a look at Minion Backup perhaps? or the Backup from Ola Hallengren? Both also do Index Rebuild etc.
September 17, 2015 at 8:42 am
Sean Lange (9/17/2015)
I compiled all the suggestions into a single query just so you can see them side by side.
All you need now is to be able to SET STATISTICS...
September 17, 2015 at 7:39 am
Would a binary collation on the REPLACE do the trick?
September 17, 2015 at 7:32 am
Do you need BIGINT for FKey to user? That's a lot of users! (and twice the width for each index entry / half the index keys per-index-page)
What about NVarchar?...
September 17, 2015 at 7:30 am
Note sure what your latent data consists of, but my expectation would be:
A database of size 40GB with largest index 10GB would need a maximum of 50GB for the index...
September 17, 2015 at 7:19 am
My guess is that convert-int-to-string, massage with SubString, convert-String-To-Date (or Time) is going to be much slower than something purely arithmetic.
September 17, 2015 at 7:15 am
Wurstsalat (9/17/2015)
September 17, 2015 at 7:10 am
Wurstsalat (9/17/2015)
i could do this in a seperate SQL Agent Job and Trigger it after/before backup?
Rather than separate jobs how about a SQL Agent Job with multiple steps?
Step 1 :...
September 17, 2015 at 5:48 am
Don't know if it would help? but you can be connected to the database when you do the Backup (but not a Restore)
So, in principle, you could do
USE MyDatabase
BACKUP MyDatabase
Rebuild...
September 17, 2015 at 5:46 am
I expect this is obvious, but you can choose to only rebuild indexes that are fragmented. You can also Reorganise, instead of Rebuild, which uses less disk space. I read...
September 17, 2015 at 5:40 am
Daytime here, so my servers are under load and I cannot get a consistent runtime, but this one looks to perform best for me.
SELECTDateTimeFromParts(VHRGDT / 10000, (VHRGDT % 10000) /...
September 17, 2015 at 3:20 am
Wurstsalat (9/17/2015)
BACKUP LOG runs everytime
Add BEGIN ... END?
IF EXISTS
BEGIN
BACKUP DATABASE [Database] ...
BACKUP LOG [Database] ...
END
Don't think you can use "USE" to...
September 17, 2015 at 2:02 am
Very useful function, thank you.
Hopefully not a stupid question?!! but is there is reason why this is a table-valued function rather than scalar?
September 16, 2015 at 8:54 pm
Steve Jones - SSC Editor (9/16/2015)
- I present the data to a use that may or may not change something
- I...
September 16, 2015 at 8:26 pm
Lynn Pettis (9/16/2015)
Or this if you want to use a MS provided scalar function:
select *, msdb.dbo.agent_datetime(VHRGDT,VHRGTM)
from #Something
Coincidentally just been looking at something that used that function and I went to...
September 16, 2015 at 8:17 pm
Viewing 15 posts - 346 through 360 (of 476 total)