Viewing 15 posts - 8,521 through 8,535 (of 9,241 total)
its worth noting if you licence the cpus for Enterprise edition of SQL server at the host level, it will cover you for unlimited sql server cpu licences on any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2009 at 8:00 am
unless your using Redgate or Litespeed, you have have to backup the database which can take a while depending on the size. You then have to copy that file across...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2009 at 10:32 am
i would detach then re attach. Backup and restore remember that if you backup the database and restore, if any transactions get made against the old database then you'll need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2009 at 10:05 am
homebrew01 (1/10/2009)
Perry Whittle (1/10/2009)
homebrew01 (1/10/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2009 at 2:39 am
homebrew01 (1/10/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2009 at 7:30 pm
colin Leversuch-Roberts (1/9/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 10, 2009 at 9:21 am
click in the combo box and type a new database name 😉
if you right click at the "databases" node of the tree view the combo box should be empty when...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 9, 2009 at 5:52 am
SQLBOT (1/8/2009)
Virtualization creates a safe sandbox environment for sa, but does add the overhead of providing a memory and disk space for the OS.
the only caveat here is unless the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2009 at 3:41 pm
John
cant find the link at present, it detailed the NTFS cluster size and disk alignment within the windows OS. MS indicated that changing default cluster sizes,etc didnt necessarily boost performance.
I've...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2009 at 1:47 pm
Wow, some great responses here. Did I open a can of worms? I appreciate all the feedback both negative and positive. This was only ever meant to be a "quick...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2009 at 12:15 pm
option 2 should include the client
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2009 at 5:45 am
ALZDBA (1/7/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 8, 2009 at 5:41 am
ALZDBA (1/7/2009)
Truncation usually occurs after each checkpoint but can be delayed under some conditions
this is the key here, it should and generally does but there can be instances when it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 11:50 am
BOL sql2005 Dec2008 is the version
as i understood it, recovery interval option will make regular log truncations by issuing checkpoint, but in severe cases where transactions over run the checkpoint...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 11:33 am
Perry Whittle (1/6/2009)
can you post details of the job steps?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 2:52 am
Viewing 15 posts - 8,521 through 8,535 (of 9,241 total)