Viewing 15 posts - 5,641 through 5,655 (of 6,676 total)
This is a simple OUTER JOIN query - look it up in Books Online for further information.
SELECT ...
FROM dbo.TableA a
LEFT OUTER JOIN dbo.TableB b...
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
February 6, 2009 at 3:19 pm
What have you tried so far? And, what version of SQL Server 2005? Check the version for both the database and the client tools you are using.
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
February 6, 2009 at 3:06 pm
I wouldn't think so, because that is only needed to enable the full checks on a database that was upgraded from 2000.
If the database has already had that done (e.g....
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
February 6, 2009 at 1:46 pm
Tom.Thomson (2/3/2009)
It seems expensive to me, re-ednabling the clustered index implies rebuilding every index on the table.
With SQL Server 2005 and greater, rebuilding the clustered index does not force a...
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
February 4, 2009 at 2:43 pm
Neither - fill factor is defined for each index. If you are looking at the fill factor for the clustered index, then you are looking at the table.
To find...
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
February 3, 2009 at 1:28 pm
Also realize that once you break the log chain (truncating the log this way will break it) - trying to backup the log later will fail. Since you are...
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 30, 2009 at 4:30 pm
You really cannot depend upon Task Manager. You can use perfmon to determine the exact usage of memory.
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 29, 2009 at 9:40 am
BTW - setting max memory to 26GB may be too high for Standard edition. You'll want to monitor the system and lower the max memory if you start 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 28, 2009 at 4:36 pm
Select 27262976 / 1024 / 1024;
Why do you think the system is not using 26GB of memory?
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 28, 2009 at 4:32 pm
Just so you know, /PAE and /3GB have no affect on 64bit systems. You do not have to turn on AWE in SQL Server either. SQL Server on...
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 28, 2009 at 4:26 pm
It is perfectly valid to create an updatable view on two separate tables. There are certain rules that need to be followed, but you can definitely create a veiw...
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 28, 2009 at 4:20 pm
To expand a little on what Gail started - in a parameterized query where the objects are not schema qualified, even if it is exactly the same it will generate...
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 28, 2009 at 3:48 pm
Really couldn't say for sure - but, I would think you would run into performance problems with this new setup. Basically, you are going from using 12 (3 systems...
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 27, 2009 at 4:12 pm
Lynn Pettis (1/26/2009)
Using SSIS, the process would be encapsulated in a FOR EACH container (not exactly sure how i would configure) and within that I'd have the necessary "code"...
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 26, 2009 at 6:01 pm
Yes - that is correct. And, don't forget to apply all service packs that you need (SP3 would be my recommendation).
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 26, 2009 at 5:52 pm
Viewing 15 posts - 5,641 through 5,655 (of 6,676 total)