Viewing 15 posts - 3,421 through 3,435 (of 6,676 total)
fnostro (1/21/2011)
CirquedeSQLeil (1/20/2011)
Do you need to be...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 22, 2011 at 10:05 am
This forum is for Microsoft SQL Server 2008 - not MySQL. You will probably get a better response from a forum dedicated to that product.
As for your problem, there...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 21, 2011 at 5:06 pm
Craig Farrell (1/21/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 21, 2011 at 5:01 pm
Elliott Whitlow (1/21/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 21, 2011 at 4:56 pm
That would probably be available in a utility that uses Intellisense or formatting. Not something native in SSMS as far as I know.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 21, 2011 at 4:02 pm
Michael Valentine Jones (1/21/2011)
A big advantage is...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 21, 2011 at 1:28 pm
As long as you have at least one user with sysadmin privileges that can login to that instance, then you do not need to know the sa password.
In fact, you...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 21, 2011 at 1:25 pm
Patricia Johnson (1/20/2011)
Hey DBA's,I've been told to allocate 16Gig for one clustered instance and 8Gig for another. What would the settings be for Min and Max Memory?
I normally...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 20, 2011 at 2:44 pm
There are a lot of reasons something like this can happen. It can be cause by the SMB settings on the destination server/host, or various settings on the host.
To...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 18, 2011 at 3:55 pm
All versions of SQL Server have the capability of backing up to a UNC share. As long as the service account running SQL Server has access to that share,...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 18, 2011 at 3:47 pm
I think those documents are a bit mis-leading and confusing. You have to take the into account the context of the document.
Both documents are referring to enabling this feature...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 18, 2011 at 3:18 pm
GilaMonster (1/18/2011)
Craig Farrell (1/18/2011)
GSquared (1/18/2011)
...because some poor fool will try to open your multi-terrabyte database file in MS Word...
*sprays coke on the screen* Thanks Gus, you just lightened up...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 18, 2011 at 3:09 pm
I would not drop/recreate the indexes - I would disable the non clustered indexes before the load and rebuild them after the load.
To disable: ALTER INDEX {index name} ON {table}...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 16, 2011 at 10:35 am
Steve Jones - SSC Editor (1/15/2011)
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 15, 2011 at 7:37 pm
joshtheflame (1/9/2011)
DECLARE @startDate varchar(20)
DECLARE @endDate...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 15, 2011 at 3:28 pm
Viewing 15 posts - 3,421 through 3,435 (of 6,676 total)