Viewing 15 posts - 1 through 15 (of 41 total)
Jeff Moden (2/14/2009)
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
February 18, 2009 at 8:44 am
Brian Karcher
I'm the IT Manager at Progessive Metal.
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
February 14, 2009 at 8:13 pm
Jeff, I hear a non-RBAR solution coming... anyway, thanks for the awesome presentation last night at the SEMSUG at Microsoft!
I had a RBAR "discussion" with a...
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
February 13, 2009 at 6:35 am
Double-check the Windows event logs on both servers. How long did you specify to keep the trn files? I'd check permissions on the shared log shipping folder, as well as...
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
November 3, 2008 at 7:40 am
IMHO... and for future reference:
[soapbox]
I suggest avoiding any and all 3rd party backup tools for any and all versions of SQL Server. The native backup methods are the...
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 22, 2008 at 8:36 am
Ratheesh.K.Nair (10/17/2008)
How can i execute the same for a particular column.I want to convert all the the values in that particular coulmn
select convert(varchar(30),cast(MyLongDateField as datetime),101) from MyTable
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 17, 2008 at 6:58 am
Yes, you should be able to...but try it out.
In fact, the date doesn't even need to be fully formatted:
select convert(varchar(30),cast('Oct 2 08' as datetime),101)
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 16, 2008 at 1:02 pm
Just use the normal cast, then modify the datetime to fit whatever format you need:
select cast('October 02 2008' as datetime)
The full command is:
select convert(varchar(30),cast('October 02 2008' as datetime),101)
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 16, 2008 at 12:48 pm
Thanks... so far these suggestions match my thoughts pretty well. In general, and especially on smaller systems, I leave tempdb alone. I don't set a max size limit on...
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 15, 2008 at 6:00 am
It seems like you are starting in the right place. For larger databases, I would also suggest looking at the location of your mdf/ldf files, tempdb size/location, and disk configuration...
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 14, 2008 at 11:37 am
jsph152 (10/14/2008)
This box has not had anything changed on it in well over a year...
Leaving a MS server alone for a year? There's your problem... 😀
In any...
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 14, 2008 at 11:32 am
The_SQL_DBA (10/14/2008)
Batching the index job in two sets : Does that mean I issue multiple DBCC commands?
Yes...just take your script above and make 2 copies. Set one to run on...
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 14, 2008 at 11:29 am
The_SQL_DBA (10/14/2008)
It took 4-5 hours to rebuild one Index(clustered)
So test (12 hrs) is nearly three times as slow as production (4-5 hrs). What issue are you tyring to address?
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 14, 2008 at 11:18 am
I think you've answered your own question... But in any case, I'd separate this out into 2 batches: run the smaller tables first, then the big tables. I'd run...
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 14, 2008 at 10:36 am
I'd suggest using the "Transfer Jobs Task" in SSIS.
_______________
bkDBA
0.175 seconds -- 10 year average margin of victory at the Daytona 500
212 Degrees
October 10, 2008 at 9:45 am
Viewing 15 posts - 1 through 15 (of 41 total)