Viewing 15 posts - 48,181 through 48,195 (of 49,552 total)
Style differs from one programmer to another. We all have our prefered way of writing things.
Other things. Variable and class naming (where appropriate) Use of whitespace. Placing of brackets,...
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
November 22, 2007 at 1:25 am
That's a nice tax level. I lose around 45% of my salary to tax.
Tt's a big incentive to go solo. The tax rates for self-employed is lower to start...
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
November 22, 2007 at 12:39 am
Bob Fazio (11/20/2007)
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
November 22, 2007 at 12:38 am
Malcolm Daughtree (11/21/2007)
NONE.
You never use CheckDB on your systems?
Index rebuilds don't need DBCC anymore (alter index ... rebuild) and most of the other DBCCs aren't needed except...
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
November 22, 2007 at 12:26 am
Your new query contains a correlated subquery (subselect in the select clause)
Depending on the optimiser, it's quite likely that the subquery will be executed for each row of the outer...
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
November 22, 2007 at 12:19 am
The second is a correlated sub query. Depending on the optimiser, it's ikely that the subquery will be executed for each row of the outer query. Essentially, it's a cursor...
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
November 22, 2007 at 12:17 am
Joe Contreras (11/21/2007)
Now I'm back playing the political game, and the work that needs to be done becomes secondary.
Time for some polishing of the CV?
I'm in almost the...
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
November 21, 2007 at 11:36 pm
James Horsley (11/19/2007)
So MS could add a performance boost in SQL2009 by short circuiting ...
I don't think so.
Bear in mind that SQL is a declarative language, not a procedureal one....
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
November 21, 2007 at 11:34 pm
Ouch. I've got 447 coming up in 3 weeks. I'm not looking forward to 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
November 21, 2007 at 5:42 am
Assuming that you're using SQL 2005 (you are posting this in a SQL 2005 forum), the row number function will do exactly what you want.
select ROW_NUMBER() OVER (PARTITION BY c3...
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
November 21, 2007 at 1:11 am
Sure. As an example
CREATE VIEW MyView AS
SELECT Col1, Col2, Col1+Col2 AS CalculatedColumn FROM SomeTable
GO
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
November 20, 2007 at 11:46 pm
Andrew_Webster (11/20/2007)
"book" v "books"... hmmm.Anyone else's take on this...?
I always name my tables plural and my columns singular. Table name is Books, the column that contains the book's title is...
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
November 20, 2007 at 11:43 pm
First questions that come to mind.
What's the database for?
What's going to be stored in it, for how long and why?
Who's going to be using this and how?
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
November 20, 2007 at 8:45 am
harald_m_mueller (11/20/2007)
As a rule of thumb, clustered indices should be on the (logical or technical) primary key
I would argue with that. The best place for the clustered index...
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
November 20, 2007 at 8:34 am
It's a server-wide permission. Traces aren't database objects, they trace the entire instance.
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
November 19, 2007 at 11:55 pm
Viewing 15 posts - 48,181 through 48,195 (of 49,552 total)