Viewing 15 posts - 16,741 through 16,755 (of 19,564 total)
Paul White (3/8/2010)
Ok, so I was bored :laugh:
err...Understatement??:-P
March 8, 2010 at 1:45 pm
Roy Ernest (3/8/2010)
Ok..I am hooked...What does it depend on?
Who pays for the trip. :-P:-D:-P:-D:-P
Being the multicentair that I am, it would seriously depend on time of year, who else is...
March 8, 2010 at 1:38 pm
Roy Ernest (3/8/2010)
A theoretical question....
If a SQL Saturday was arranged in our tiny island of Curacao,...
March 8, 2010 at 1:30 pm
GilaMonster (3/8/2010)
george sibbald (3/8/2010)
ok, now is this a double bluff or is jason not paying attention?Somehow I suspect the latter. 🙂
hmmm.
Jason must not be paying attention. I thought George...
March 8, 2010 at 1:29 pm
george sibbald (3/8/2010)
It really frustrates me when people post replies and repeat almost exactly what I said minutes or hours earlier
does anyone else feel that...
March 8, 2010 at 1:17 pm
I suggest creating the maint plan first then. Once the maint plan is done, then I would either create a new SSIS package, or alter your maint plan from...
March 8, 2010 at 1:12 pm
Here's another script. This uses the suggestion by Ron.
Declare @DBNamevarchar(50)
Set @DBName = 'YOURDBNAME'
Select Db_name(ps.database_id) as DBName,object_name(ps.object_id) as TableName,I.name as IndexName
,sum(isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) as IndexSizeBytes
,sum((isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) /1024/1024) as IndexSizeMB
From...
March 8, 2010 at 1:07 pm
To create a Backup Plan
To manage the files on disk:
March 8, 2010 at 12:28 pm
ramadesai108 (3/8/2010)
March 8, 2010 at 12:23 pm
dbychen (3/8/2010)
"how do you come to the...
March 8, 2010 at 12:20 pm
dohomebiz (3/8/2010)
DISREGARD
Does that mean you figured it out?
March 8, 2010 at 12:10 pm
dohomebiz (3/8/2010)
select * from detail
and gettign the following error
Major Error 0x80040E37, Minor Error 0
> select * from detail
The specified table does not exist. [...
March 8, 2010 at 12:09 pm
Roy Ernest (3/8/2010)
Of Topic...On an average how many people attend SQLSaturdays?
Good question.
I think this last one hit 1000.
March 8, 2010 at 11:41 am
Steve Jones - Editor (3/8/2010)
I'm noting that if you feel you are impaired, you ought to be responsible enough to tell your boss you can't work.
I think a key...
March 8, 2010 at 11:28 am
Viewing 15 posts - 16,741 through 16,755 (of 19,564 total)