Viewing 15 posts - 5,566 through 5,580 (of 18,926 total)
It's a 20% sample... so check 1 row, skip 4, check 1 row... etc.
Not sure this is exactly how it is implemented but it wouldn't make any sense to scan...
June 2, 2011 at 5:54 am
ridzuan_first (6/2/2011)
My only thing I need to do is delete the old database files older than 7 days.
Search this site for scripts... there are plenty that do that. Mine...
June 2, 2011 at 5:46 am
Sayeed Master (6/2/2011)
Yup you're right. Thanks for the hint about the inner join, thats alot cleaner method. Apologies but I'm new to SQL, still learning.Just a means to end.
We've all...
June 2, 2011 at 5:45 am
That's SSMS you need to see what the app settings are once connected to the server.
Start a default trace and paste the value of the event existing connection.
It should look...
June 2, 2011 at 5:42 am
For reallllllllly basic you can go to w3schools.
After that you can read and search problems on this forum... and then ask questions for what you don't find.
June 1, 2011 at 2:17 pm
SQL Guy 1 (6/1/2011)
But what the difference it makes for you how you call yourself Junoir, Senior.
For me... nothing. I've always been the only DBA so I just...
June 1, 2011 at 2:12 pm
sqlfriends (6/1/2011)
I do need a way to figure out how fast the database grow.
I will give a try of the script.
Also is the database full backup file size...
June 1, 2011 at 2:04 pm
Vertigo44 (6/1/2011)
Ninja's_RGR'us (6/1/2011)
Just move the user databases to the new drive.
quote]
I'm not sure I understand you... I could be mistaken but wouldn't I want to move...
June 1, 2011 at 2:01 pm
Then try this, don't rebuild the index but only do the stats.
I'm pretty sure that doing a simple update stats with 20% should be enough and wouldn't take hours to...
June 1, 2011 at 1:58 pm
Feanor (6/1/2011)
still same problems.
I triple checked regional settings.
Regional / Format: Slovenian,
Location - Slovenia
Keyboard - slovenian
so (input language, format, location) all set to slovenia.
I'm logged as administrator and I have...
June 1, 2011 at 1:57 pm
GilaMonster (6/1/2011)
Great, not go back and look at Ninja's comments on this trigger.It will NOT work properly if more than one row is affected by Insert.
And AGAIN. WHY oh...
June 1, 2011 at 11:50 am
sqlnaive (6/1/2011)
Thereafter our batch starts which populates...
June 1, 2011 at 11:47 am
GilaMonster (6/1/2011)
Missed that.Ok, for the rest, replace the EXEC with Print (and remove the brackets) and post the printed out statement
Looks like a fixed by posting a question effect.
I did...
June 1, 2011 at 11:35 am
BTW I still don't understand why you need to run this in a proc.
And your trigger still fails if more than 1 row is affected in the transaction that fires...
June 1, 2011 at 11:34 am
Viewing 15 posts - 5,566 through 5,580 (of 18,926 total)