Viewing 15 posts - 4,291 through 4,305 (of 18,926 total)
Sounds like a good plan.
You can use something like this as well :
SELECT CHECKSUM(NEWID()) % 10000 + 1 FROM sys.columns
This will generate random numbers. From that you can...
July 28, 2011 at 9:19 am
PS I run reports live from the prod DB (sub-optimal setup) with larger tables than yours and I usually get the results sub-second. My longest reports run under 1...
July 28, 2011 at 9:15 am
Wow this is not a small query (sent via PM). Ideally you'd repost it here but I understand if you can't or don't want to... but plz understand we...
July 28, 2011 at 9:13 am
Ignacio A. Salom Rangel (7/28/2011)
Ninja's_RGR'us (7/28/2011)
brown-415622 (7/28/2011)
Thanks I will try this, is it ok to try this during production hours?
I have never seen / tested that scenario and I don't...
July 28, 2011 at 9:05 am
Ignacio A. Salom Rangel (7/28/2011)
Ninja's_RGR'us (7/28/2011)
Ignacio A. Salom Rangel (7/28/2011)
brown-415622 (7/28/2011)
July 28, 2011 at 9:04 am
Well ya. Why copy the data if you don't want it?
Seems easier to just built it once then forget about it.
If you need to tune a specific...
July 28, 2011 at 9:01 am
Easier to do it at your current job on a new project.
Or a very junior job in a big company.
The problem with BI is that this is one of the...
July 28, 2011 at 8:56 am
brown-415622 (7/28/2011)
Thanks I will try this, is it ok to try this during production hours?
Actually I wouldn't wait. In theory, you can't create a new DB untill this is...
July 28, 2011 at 8:53 am
Ignacio A. Salom Rangel (7/28/2011)
brown-415622 (7/28/2011)
It was a fresh install. Just noticed that the database was in stuck in restore state a day or two later.
So, you did not restore...
July 28, 2011 at 8:50 am
Grubb (7/28/2011)
So, the difference between 5 and 10 is enough to really bloat it?
K, so this was a...
July 28, 2011 at 8:04 am
SNAPSHOT ISOLATION is 1 option but this will increase the load in tempdb.
One other option is to build a local temp table in your stored procedure. Take all the...
July 28, 2011 at 8:01 am
Lavanyasri (7/28/2011)
I am SQL server Standard edition[64 bit ] sp3 , i am planning to create a maintenance plan through wizard , but my wizard is not opening...
July 28, 2011 at 7:52 am
Wow, looks awesome :-P.
And the picture too.
(Just saw your home site ;-))
July 28, 2011 at 7:50 am
jeff.mason (7/28/2011)
Not bored, but was indeed waiting for 5. It was one of those days.
My telepathy is fianlly kicking in ;-).
July 28, 2011 at 7:48 am
ajsnyman (7/28/2011)
Ninja's_RGR'us (7/28/2011)
Now this is getting expansive :w00t:!Crazy :crying:
yup, 1 per user even if they don't use it everyday.
Basically if one person NEEDS to access the server / data you...
July 28, 2011 at 7:47 am
Viewing 15 posts - 4,291 through 4,305 (of 18,926 total)