Viewing 15 posts - 42,031 through 42,045 (of 49,571 total)
RBarryYoung (1/2/2009)
Can you show us the execution plan?
Additionally, the schema of the tables and the index definitions would be of great help.
January 3, 2009 at 7:44 am
thuybui (1/2/2009)
A database is in "It is in the middle of a restore" state. How do I release that state for that database? Thanks.
What did you do to get it...
January 3, 2009 at 7:37 am
Is autoshrink on for that database?
January 3, 2009 at 7:34 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
January 3, 2009 at 7:31 am
What's this function supposed to do?
I'd offer help in getting rid of the cursor, but I have absolutely no idea what it's doing.
January 3, 2009 at 7:26 am
madhu.arda (1/2/2009)
We have data files on D drive and log files on F drive and tempd on G drive and Backups are Z drive
Are those separate physical drives, or partitions...
January 3, 2009 at 7:25 am
branovuk (1/2/2009)
"...A full database backup backs up the whole database. This includes part of the transaction log so that the...
January 3, 2009 at 7:08 am
Mad-Dog (1/2/2009)
SQL 2005.yes i'm seeing that my tempdb database sometimes grow for 40-50GB.
That's not what I asked. I asked if you're seeing large temp tables that stay around for...
January 2, 2009 at 5:31 am
If you create an inline table-valued function (which you have, by specifying just RETURNS TABLE), it must be a single select statement. If you want control flow, then you need...
January 2, 2009 at 5:02 am
ervin_brosas (1/1/2009)
I need to migrate the database from SQL 2005 to SQL Server 2000.
The only way to do that is to script all of the objects out, bcp all the...
January 2, 2009 at 4:02 am
talk2riya15 (1/1/2009)
i want to add more column dynamically by using store procedure......how can i do this????
Why do you need to do this?
January 2, 2009 at 2:14 am
Mad-Dog (1/2/2009)
January 2, 2009 at 2:05 am
David O (1/1/2009)
Pretty sure now it is the version of Sql and the OS I'm trying to use instead of 32 bit on x64 bit OS.
What edition of SQL...
January 2, 2009 at 12:18 am
GilaMonster (1/1/2009)
Please post table structure (as create table statements), some sample data and your expected results. Read this to see the best way to post this to get quick responses.http://www.sqlservercentral.com/articles/Best+Practices/61537/
January 2, 2009 at 12:15 am
David O (12/31/2008)
I just rebuilt my work station Win x64 ... and the RTM disk tells me my OS isn't supported.
What OS are you using? What edition of SQL...
January 1, 2009 at 2:19 pm
Viewing 15 posts - 42,031 through 42,045 (of 49,571 total)