Viewing 15 posts - 41,656 through 41,670 (of 49,571 total)
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
Not a bad question, but does this guy ever read the posts that he's answering?
http://www.sqlservercentral.com/Forums/FindPost638650.aspx
Question was "I didn't start an explicit transaction, I don't have a backup, how do I...
January 17, 2009 at 1:01 am
kiransuram19 (1/16/2009)
(I am confused little bit)..That means when we take a backup it only consider .mdf file size ?
The mdf and enough of the log to be able to restore...
January 17, 2009 at 1:01 am
Paresh Prajapati (1/16/2009)
otherwise if u take transaction log backup..then restore full bakup with norecovery and apply log with recovery..
Except that he said he doesn't have a backup.
January 17, 2009 at 12:51 am
Themis Tokkaris (1/16/2009)
If I create a Database Backup from a SQL Server 2008 Instance, can I restore this backup on a SQL Server 2005 Instance?
No. It is never possible to...
January 16, 2009 at 1:57 pm
The only way you can do that on SQL 2005 is to install a second instance, put some of the DBs on the second instance and change the CPU affinity.
2008's...
January 16, 2009 at 12:39 pm
colin Leversuch-Roberts (1/16/2009)
only if you haven't been using the san I've been testing!!!!
There are worse ways to kill a SAN's performance than RAID 6.
Share the OLTP system's fibre switch with...
January 16, 2009 at 12:14 pm
Viewing 15 posts - 41,656 through 41,670 (of 49,571 total)