Viewing 15 posts - 5,596 through 5,610 (of 6,676 total)
I think I understand what you are trying to do, but I am not sure it is needed. Can you just create a new formatter procedure with the 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
February 27, 2009 at 3:47 pm
barunpathak (2/27/2009)
No..still not getting what i wanted to...
Okay, so what have you tried and why does it not work? Read the article in my signature and post some create...
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 27, 2009 at 3:33 pm
I ran into this issue before and found the only way to get this information was to get it from a server side trace. I was not able 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
February 27, 2009 at 3:28 pm
Okay - wasn't sure, but since your are on SQL Server the EXCEPT operator is available and can be used.
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 27, 2009 at 3:19 pm
SELECT REPLACE(col2, '\' + col1, '');
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 27, 2009 at 2:54 pm
Your query does not look like T-SQL, so I don't know if this will work in your product. In T-SQL we could use the EXCEPT operator, as in:
SELECT {column...
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 27, 2009 at 1:54 pm
One of the things I noticed is that the SPN record must match exactly how you are connecting to SQL Server. In other words, if your SPN is setup...
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 26, 2009 at 2:23 pm
The default max memory setting after install is 2TB, regardless of the amount of memory available on the server.
On x64 platforms - you want to always set the maximum 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
February 25, 2009 at 3:25 pm
noeld (2/25/2009)
Watch out for SQL 2005 has issues with ORDER BY in the definition of the views!
No, the only time it is not valid is when you use TOP 100...
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 25, 2009 at 3:23 pm
In addition to what GSquared stated, how many rows out of the 20,000,000 rows have a value in col2?
If most of those are populated, then SQL Server is going 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
February 25, 2009 at 2:16 pm
Jason Crider (2/25/2009)
What about the portability of not deal with a third party file extension?
What about your backup and restore scripts working anywhere...
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 25, 2009 at 2:12 pm
Besides compression, the number one reason we use Litespeed is speed.
I can backup my 350GB database, with compression to a 60GB file in about 40 minutes.
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 25, 2009 at 1:32 pm
steve smith (2/24/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
February 24, 2009 at 2:27 pm
What you are stating is not possible - if the database is restored. If there are views that don't exist in the other instances, they must exist in 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 24, 2009 at 1:51 pm
Your co-worker is correct - column order has no bearing on how SQL Server places the columns in the b-tree.
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 24, 2009 at 9:52 am
Viewing 15 posts - 5,596 through 5,610 (of 6,676 total)