Viewing 15 posts - 6,001 through 6,015 (of 6,676 total)
FYI - changing/setting the option for sqlservercentral.com to display pages in Compatibility Mode fixes this little problem 🙂
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
October 24, 2008 at 10:28 am
Sorry for coming across as harsh - but, it is better that you learn how to avoid this now than to be bitten later. Especially in this situation where...
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
October 23, 2008 at 5:20 pm
Barry, if you check Narayana Vyas Kondreddi website (http://vyaskn.tripod.com you'll see that is the exact reason this was created.
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
October 23, 2008 at 4:29 pm
john (10/23/2008)
To the other point. Yes I understand injection but this...
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
October 23, 2008 at 4:27 pm
So, why don't you use SQLCMD instead? That is the new command line tool for SQL Server 2005.
BTW - errors like that would also show up in SSMS if...
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
October 23, 2008 at 4:23 pm
What kind of errors are you getting?
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
October 23, 2008 at 3:48 pm
Take a look at the DMV's:
sys.dm_db_index_operational_stats
sys.dm_db_index_usage_stats
You should be able to get the information you want by looking at only the heaps and clustered indexes. That is, indexes with an...
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
October 23, 2008 at 3:27 pm
Lookup CASE in Books Online. You need to replace the IIF with CASE - but, that should be the only change.
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
October 23, 2008 at 12:22 pm
Well, sure - that is why I originally asked how many rows you had in your Tally table. However, even if you limit your Tally table to 11,000 rows...
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
October 22, 2008 at 5:31 pm
Not really - it is actually simpler than that. The where clause has to be evaluated for every row in the set. Since your table has 1,000,000 rows...
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
October 22, 2008 at 5:13 pm
You cannot connect to SQL Server 2005 Reporting Services from the 2008 client tools. You need to use the 2005 client tools.
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
October 22, 2008 at 5:07 pm
Remember how queries work:
First, process the joins. In this case there are no joins - so we need to work on the full set of data which is 1,000,000...
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
October 22, 2008 at 5:01 pm
How many rows do you have in your Tally table? I run this fine with 11000 rows.
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
October 22, 2008 at 2:45 pm
I seem to remember getting that error on an older version. I ended up using the SSMS plug in, setting it up for the deletion I wanted and then...
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
October 22, 2008 at 2:29 pm
SELECT ...
FROM table1 t1
LEFT JOIN table1 t2 ON t2.key = t1.key AND t2.ID_SET_STATUS_TYPE = 3
WHERE t1.ID_SET_STATUS_TYPE = 1;
Need to identify the key column(s) 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
October 21, 2008 at 2:40 pm
Viewing 15 posts - 6,001 through 6,015 (of 6,676 total)