Viewing 15 posts - 41,641 through 41,655 (of 49,562 total)
Jeff Moden (1/17/2009)
how can you possibly think he's wrong?
Well, it's not that he's wrong. That's a perfectly correct answer, just to a different question. It's the same as...
January 17, 2009 at 2:09 pm
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions. All this does is waste everyone's...
January 17, 2009 at 2:06 pm
Just databases that are currently attached to the instance. If it was very recent, check out the default trace. It should have info on dropped databases. You'll find the .trc...
January 17, 2009 at 1:57 pm
MichaelJasson (1/17/2009)
I wanted to understand where this backup is taken. I couldn't find the backup of the transaction log.
It's not. That's the whole point. TRUNCATE ONLY means don't write out...
January 17, 2009 at 1:53 pm
Jeff Moden (1/17/2009)
the thing is that Ranking can take care of that one because you're grouping by day.
No, I'm not. A group is any number of events that are...
January 17, 2009 at 1:51 pm
bravadortb (1/17/2009)
I'm wondering if there is a correct order in which the columns should appear in the WHERE clause?
Not at all. The order that you specify has nothing...
January 17, 2009 at 1:07 pm
INCLUDE columns?
Only the columns in the where need to be in the index key The rest can be include cloumns, and there's no limit to either size of number...
January 17, 2009 at 12:46 pm
Actually, SQL knows they're numeric. The error comes from trying to concatenate a numeric value into a string. It's trying to convert 'delivered' into numeric, which isn't going to...
January 17, 2009 at 10:41 am
Please post the table and index definitions and the execution plan (saved as a .sqlplan file, zipped and attached to your post)
I could guess without that info but it would...
January 17, 2009 at 10:05 am
Ninja's_RGR'us (1/17/2009)
Since when reading the full question a requirement of posting an answer?😀
Good point. :hehe:
Grant Fritchey (1/17/2009)
January 17, 2009 at 8:36 am
Run sp_spaceused on the database and on each of the tables in the database. That should show you where the space is been used, or if it's free space within...
January 17, 2009 at 8:32 am
I hate to be blunt but that procedure's absolutely huge (560 lines) and I don't have the spare time to work through that size of proc.
Can you narrow down where...
January 17, 2009 at 8:30 am
kiransuram19 (1/17/2009)
NO_LOG | TRUNCATE_ONLYGilaMonster --- This above is the answer I was looking for.
No, it's not. You stated (in the post that you deleted) that you don't want to break...
January 17, 2009 at 4:11 am
I've got a similar one that I'm working on, that does have a legit business requirement. I don't need a solution, I did figure one out after staring at it...
January 17, 2009 at 2:01 am
kiransuram19 (1/17/2009)
1) How can I Truncate T log so that it can only delete the in-active transactions in the log fileand this should
Did you read the article that...
January 17, 2009 at 1:54 am
Viewing 15 posts - 41,641 through 41,655 (of 49,562 total)