Viewing 15 posts - 1,186 through 1,200 (of 1,584 total)
The only ways I can think of accomplishing this is to 1) do it in a reporting services report or 2) use temp tables
1) Create a reporting services report (or...
February 22, 2012 at 3:25 pm
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?
February 22, 2012 at 1:41 pm
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...
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...
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 @...
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 '
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...
February 22, 2012 at 6:32 am
Perhaps something like this?
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...
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
...
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,...
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...
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...
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%...
February 21, 2012 at 12:57 pm
Viewing 15 posts - 1,186 through 1,200 (of 1,584 total)