Viewing 15 posts - 6,421 through 6,435 (of 6,676 total)
Do you want the new named instance to be clustered? If so, then yes - you need to add a new SQL Group, dedicated drives, etc...
If this new names...
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
June 25, 2008 at 1:38 pm
Bryan Mischler (6/25/2008)
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
June 25, 2008 at 1:36 pm
[quote-0Here is the order of operations:
Double-click a server name\ctrl-C\Connect in object explorer\Database engine...\Paste Server Name\Connect.
That adds up to 9 clicks and keystrokes (if my addition is correct).
8 servers multiplied by...
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
June 25, 2008 at 12:54 pm
Jeff Moden (6/24/2008)
jimige257 (6/24/2008)
Is it worth spending 2 hours optimizing a prodedure that works now and is needed last week? Many would say not.
And, THAT is why I tell folks...
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
June 24, 2008 at 9:26 pm
COUNT(*) AS TotalRows, SUM(case when Status='P' then 1 else 0 end) AS Present, SUM(case when Status='A' then 1 else 0 end) AS Absent
FROM Attendance WHERE sid=studentnumber
Now, how can I...
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
June 24, 2008 at 9:01 pm
I think you can connect to MySQL using SSIS and extract data that way. Another method would be to create a linked server in SQL Server, create a new...
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
June 24, 2008 at 8:38 pm
TheSQLGuru (6/24/2008)
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
June 24, 2008 at 10:13 am
How much free space do you have available in the database?
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
June 23, 2008 at 11:37 pm
How big is the log file for this database? What is the recovery model for the database? If full recovery, how often do you backup the transaction log?
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
June 23, 2008 at 11:14 pm
TheSQLGuru (6/19/2008)
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
June 23, 2008 at 10:59 pm
maruf24 (6/23/2008)
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
AFTER CHECKALLOC
DBCC SHOWCONTIG scanning 'TABLE' table...
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
June 23, 2008 at 10:50 pm
Yes, that is possible - it means you have 10mb of data in the database and 30mb of space available (give or take a few mb) until the data file...
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
June 23, 2008 at 10:43 pm
You can review this thread: http://www.sqlservercentral.com/Forums/Topic521489-338-1.aspx
How you proceed will all depend upon how you are going to calculate each value. Are they all SUM's or is one a SUM...
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
June 23, 2008 at 8:55 pm
What are your setting on the linked server for:
Collation Compatible
Use Remote Collation
Collation Name
You can try changing these to see if this corrects the problem. I have had situations when...
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
June 23, 2008 at 3:06 pm
My guess is that you really need to look at tuning the query. Without seeing the query, sample data, etc... I could not begin to guess at how 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
June 23, 2008 at 11:08 am
Viewing 15 posts - 6,421 through 6,435 (of 6,676 total)