Viewing 15 posts - 40,081 through 40,095 (of 49,571 total)
Please post table definitions and sample data. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 1, 2009 at 12:12 pm
Why do you need to shrink it? If it's grown that large it means that something within your production workload needs a 16 GB tempDB. If you do somehow force...
April 1, 2009 at 12:01 pm
tianyongsun (4/1/2009)
select * from test where username = convert(varchar(256),user_name())
The plan for the first query is a clustered index scan, whereas the plan for...
April 1, 2009 at 12:01 pm
manoj kumar (4/1/2009)
I think, i can not change the structure of the extisting table because big application is running on that sturcture.
Change and rename the tables and then stick a...
April 1, 2009 at 10:23 am
You escape quotes by doubling them.
Set strwhere = 'C.IT_Code IN (''A'',''E'',''C'',''P'',''R'',''O'') AND SP.Status=''S'' and SP.PayDT <> ''********'' AND (NOT (C.ContractStatus IN (''D'', ''X'')))'
April 1, 2009 at 9:44 am
Is that table properly normalised? Do all of those columns belong in there?
April 1, 2009 at 9:41 am
pedro.ribeiro (4/1/2009)
I'm thinking in putting some staging tables on tempdb.
This are empty tables that receive some data from a bulk insert and then i...
April 1, 2009 at 9:30 am
Mark Douglass (4/1/2009)
Can you say sheepish quiet?
Yup. Seen it enough times with devs that I used to work with. Usually after they had told me that a query was running...
April 1, 2009 at 9:16 am
Vijaya Kadiyala (4/1/2009)
You can even use Column Name in palce of * but it depends on the requirement.
You can, but it'll very likely be slower than count(*). Also COUNT(Column)...
April 1, 2009 at 9:10 am
pandeharsh (4/1/2009)
SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_name') AND indid < 2
That's not guaranteed accurate. Also, sysindexes is a deprecated system view and will be removed in future versions....
April 1, 2009 at 9:08 am
Lynn Pettis (3/31/2009)
Does this mean that the posts may be gettng better, or are we just showing greater tolerance for the moment??
Better? I think not. So far today:
What's a production...
April 1, 2009 at 9:05 am
Lynn Pettis (4/1/2009)
Also, to be sure, are you still using SQL Server 2000?
Nope, that's 2005 or 2008. There's a CTE and a pivot in there. I'm requesting a move to...
April 1, 2009 at 9:04 am
Mark Douglass (4/1/2009)
Since we JUST upgraded this server from 2000->2005 the week before, he claimed that this behavior was a problem with the new install of 2005.
Why do developers...
April 1, 2009 at 8:57 am
gregorybrunner (4/1/2009)
table becomes clean. Unfortunately we lost 12 records. Is there a way to get this table
clean without the loss...
April 1, 2009 at 8:44 am
Jeff Moden (3/31/2009)
does anyone know what "sleep" means? :hehe:
Sorry, not a clue.
I think it's that thing you're supposed to do late at night, you know when we're still working.
April 1, 2009 at 8:32 am
Viewing 15 posts - 40,081 through 40,095 (of 49,571 total)