Viewing 15 posts - 40,066 through 40,080 (of 49,552 total)
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'')))'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2009 at 9:44 am
Is that table properly normalised? Do all of those columns belong in there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2009 at 8:32 am
Mark Douglass (4/1/2009)
I just want to understand why the behavior works the way it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2009 at 8:28 am
Peso (4/1/2009)
Not necessarily. With SQL 2008 comes the ability of Filtered Indexes.You can create an index on Bit1 = 1 only.
Sure you can, but that doesn't change the selectivity rules....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2009 at 8:15 am
ABurton (3/31/2009)
A vendor has requested that I change all BIT fields to TINYINT because, as they say, the MSSQL Query Optimizer does not include BIT fields in its optimizations.
They're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 1, 2009 at 1:16 am
Mark Douglass (3/31/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 31, 2009 at 4:04 pm
Viewing 15 posts - 40,066 through 40,080 (of 49,552 total)