Viewing 15 posts - 5,206 through 5,220 (of 18,926 total)
Ray K (6/28/2011)
Man, you're not kidding about the tweaks!I got the jist of it, nevertheless. Thanks!
This concept is a litter harder to comprehend so I can't just give you...
June 28, 2011 at 9:23 am
Here's a sample concat code. Enjoy the little tweaks!
SELECT
T.name,
STUFF((
SELECT
...
June 28, 2011 at 8:54 am
paul.knibbs (6/28/2011)
Ninja's_RGR'us (6/28/2011)
Just my 0.02$... MS decided that 1 GB ram and 4 GB data was what they were prepared to give for free.
10Gb data in SQL Express 2008...
June 28, 2011 at 7:23 am
Sumanta Roy (6/28/2011)
But the backup will always have less size than actual database size. So can you please clarify if this calculation will give me the exact data growth?
The backup...
June 28, 2011 at 7:07 am
It's not worth much... no site, no traffic, no monetization method in place.
You'll be lucky to get an offer in the 3 figures... definitely not 4.
June 28, 2011 at 6:54 am
Just my 0.02$... MS decided that 1 GB ram and 4 GB data was what they were prepared to give for free. Trying to go around that feels...
June 28, 2011 at 6:44 am
Lowell (6/28/2011)
CREATE PROCEDURE AVOIDSNIFFING(@Param1 int=0,@Param2 datetime = NULL)
AS
DECLARE @localParam1 int,
...
June 28, 2011 at 6:42 am
June 28, 2011 at 6:38 am
Those articles are a great read and I would strongly recommend you read them.
HOWever,
I've been having a very similar issue in bids where the local machine just ain't strong...
June 28, 2011 at 6:32 am
george sibbald (6/27/2011)
I read it as the backup was too big to fit on a DVD, rather than data files out of space on disk.
Brainfart! I had another thread...
June 27, 2011 at 6:17 pm
george sibbald (6/27/2011)
If the database is not being reindexed, that might be enough to take the backup...
June 27, 2011 at 4:55 pm
... because he said no 3rd party app!
I agree tho... it can easily give between 50% and 90% compression.
I also like the blue-ray idea. Not the longest fix to...
June 27, 2011 at 4:50 pm
Dude take 2 freaking minutes and apply my solution. You'd be done by now!
June 27, 2011 at 4:48 pm
GilaMonster (6/27/2011)
No. I meant these:http://www.sqlservercentral.com/articles/64582/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Hard to copy-paste links when posting from an iPad (which I was earlier)
Cool, tho all 4 are good reads :w00t:.
June 27, 2011 at 2:54 pm
archangel717 (6/27/2011)
For the intense index defrag script... will this solve the massive amounts of data being written to T-LOG during my maintenance plans? I'm inferring that you...
June 27, 2011 at 2:52 pm
Viewing 15 posts - 5,206 through 5,220 (of 18,926 total)