Viewing 15 posts - 4,996 through 5,010 (of 6,676 total)
If you install SSMS 2008, you can use the filter option to filter the list of tables to only those you want and script them.
Or, if you install Powershell and...
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 17, 2009 at 2:38 pm
The version that shows up there may not reflect the current version. To validate the client tools you need to look at the properties of the executables and dll's.
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 17, 2009 at 2:14 pm
GilaMonster (6/17/2009)
Florian Reischl (6/17/2009)
Erm... Just played with this nullbuster. This might be an important information for you:
This feature works find on SSE2k5 but it does not work anymore on SSE2k8...
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 17, 2009 at 2:00 pm
I would recommend not using a single file device and continue using multiple files. The problem you are going to run into is very simple. Part of your...
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 17, 2009 at 1:58 pm
What kind of maintenance would that be? Let's think about this...
Update Statistics? Nope, no tables there that we would want to update.
Rebuild/Reorganize Indexes? Again, nothing there 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 17, 2009 at 1:50 pm
SA (6/17/2009)
I recently purged ~ 26GB staging data from 31 GB database and didn't want to leave 26GB of free space in the...
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 17, 2009 at 1:46 pm
How are you determining that the client tools have not been upgraded?
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 17, 2009 at 1:43 pm
SA (6/17/2009)
1. Shrink database to required size (include enough room to rebuild all indexes)
2. Rebuild all indexes
3. Backup database
4. Drop the database
5. Create 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 17, 2009 at 1:31 pm
GSquared (6/17/2009)
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 17, 2009 at 12:56 pm
GSquared (6/17/2009)
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 17, 2009 at 12:15 pm
Florian Reischl (6/17/2009)
Jeffrey Williams (6/17/2009)
Hmm - works fine for me. Are you sure it isn't failing because you already have a row with a 1 in the X column?
Well,...
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 17, 2009 at 11:36 am
Florian Reischl (6/17/2009)
Erm... Just played with this nullbuster. This might be an important information for you:
This feature works find on SSE2k5 but it does not work anymore on SSE2k8 for...
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 17, 2009 at 10:46 am
verbalh (6/17/2009)
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 17, 2009 at 10:37 am
Florian Reischl (6/17/2009)
Using an indexed view is a solution I really had to see. Let me justify with the...
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 17, 2009 at 10:17 am
only4mithunc (6/17/2009)
but the solution is like keeping unique value in the column and allowing more than one NULL value....
but my...
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 17, 2009 at 10:07 am
Viewing 15 posts - 4,996 through 5,010 (of 6,676 total)