Viewing 15 posts - 1,186 through 1,200 (of 1,583 total)
I just now realized what it was you were trying to accomplish...why are you wanting to do this within SQL and not in a report or sorts?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 1:41 pm
Oops!!!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 11:37 am
I use modified versions of these scripts on DBS with over 800Gb of data...it actually works pretty well and skips the stuff not needing the index maintenance. Set the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 7:01 am
If you wrap this around the other procedure (calling the other proc from this) it will loop through all your DB's on a given server and perform the maintenance, omitting...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 6:46 am
As many people will tell you on this site, not to bother with rewriting a process that's already been done so many times before, check out Ola Hallengren's scripts @...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 6:42 am
Join on syscolumns, and add a WHERE clause to omit the following xtypes:
(34,35,99,241) --image, text, ntext, or xml '
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 6:37 am
In my experience with virtualization (limited), even a brand new VM with a fresh install of SQL can appear to be "slow", yet monitoring things like CPU/RAM/DISK usage reveal litte...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 22, 2012 at 6:32 am
Perhaps something like this?
http://www.sqlservercentral.com/scripts/Agent/86910/
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 2:53 pm
The source of the login errors, yes, but still completely in the dark as to what happened to the distribution DB. Well, at least it could be recovered!
Thanks to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 2:48 pm
Try using ROW_NUMBER() OVER(PARTITION BY) - I think that would very well for you in this scenario
Something like this maybe?
DELETE FROM a
FROM
(SELECT pid, CN, mk, te, yr, st, cr, cc
...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 2:46 pm
Yep that was exactly it 🙂
It slipped my mind (until you said that) that I set up the security using the default "Impersonate agent process account (Windows Authentication)" (I know,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 2:31 pm
Success! 😎
To tell you the truth I am blown away that there wasn't more information on this on BOL or MS forums...almost makes me feel special that I AM THE...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 2:07 pm
Rebooting of the server has allowed a checkdb to at least start, currently it's running (very slowly i.e it's been at 1% for the past 9 minutes) but it is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 1:22 pm
1. The data file is about 80GB, logfile is about 25GB, the actual usage of that portion varies, in fact most of the time the data file is only 15-20%...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 12:57 pm
No such luck in this case :(. With the checkdb not being able to create the snapshot sounds to me like a reboot is needed. Having to go this...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 21, 2012 at 11:35 am
Viewing 15 posts - 1,186 through 1,200 (of 1,583 total)