Viewing 15 posts - 33,916 through 33,930 (of 49,552 total)
CirquedeSQLeil (2/18/2010)
Is this typical behavior this time of year (after MVP nominations open up)?
???
MVP nominations are open all year round, awards given every 3 months.
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
February 18, 2010 at 11:01 am
Steve Jones - Editor (2/18/2010)
More people trying to be MVP or show off, so there's more participation.
That was my impression as well. Everyone thinks they're an ex-spurt
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
February 18, 2010 at 11:00 am
Try using RowNumber instead
SELECT [Code],
[AsofDate],
[MyValue]
FROM (
SELECT [Code],
[AsofDate],
[MyValue],
ROW_NUMBER() OVER (PARTITION BY Code ORDER BY AsofDate DESC) AS RowNo
FROM Test
AND...
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
February 18, 2010 at 10:58 am
river1 (2/18/2010)
Make a "inner join on x=Y" or make "select ..... where x not in (select y)"
Unless I'm missing something, those will not return the same result.
Table1 INNER JOIN...
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
February 18, 2010 at 10:56 am
Pleasure.
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
February 18, 2010 at 10:19 am
Ser Tharg (2/18/2010)
The database is used for syslogs. Data is periodically truncated from tables and this leaves a lot of free space.
The free space will be reused though? If it's...
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
February 18, 2010 at 10:19 am
Dan Guzman - Not the MVP (2/18/2010)
What can I say, It has avoided some confusion in the past. Mostly from 'Hi, been a long time, how have you been'...
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
February 18, 2010 at 10:09 am
See if the following indexes help
DROP INDEX [idx_SalesFact_Station] ON [dbo].[SalesFact]
GO
CREATE NONCLUSTERED INDEX [idx_SalesFact_Station] ON [dbo].[SalesFact]
([sk_Station])
INCLUDE ([sk_ContractKey],[sk_DateContractLineEntered],[sk_HeadlineNumber],[GrossRate])
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
February 18, 2010 at 9:56 am
Is it me or is the signal:noise ratio here getting worse?
Some threads lately there's been so much conflicting advice from various people that it's hard to get useful facts.
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
February 18, 2010 at 9:46 am
Is it me or is the signal:noise ratio here getting worse?
Some threads lately there's been so much conflicting advice from various people that it's hard to get useful facts.
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
February 18, 2010 at 9:46 am
Dan Guzman - Not the MVP (2/18/2010)[hr
However, you will see a substantial performance bump if you drop the with(nolocks) (per Gail) and use INNER JOIN with your 5 tables, moving...
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
February 18, 2010 at 9:40 am
The fact that the DB server is SQL 2000 is rather an important one....
Ok, amend my earlier suggestion, what does SELECT name, status, status2 FROM sysdatabases return for the databases...
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
February 18, 2010 at 9:28 am
Steve Cullen (2/18/2010)
Once upon a time, developers were concerned about developing with an eye toward backward compatability and cross-platform compatability. I don't see that much anymore.
Why would I restrict...
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
February 18, 2010 at 9:24 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Also, please be careful of Nolock. It's often used in an attempt to make queries faster by ignoring locks....
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
February 18, 2010 at 9:21 am
c.lambe (2/18/2010)
Optimise it yourself.
That comes across a little rude, I don't know if you intended it that way.
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
February 18, 2010 at 9:19 am
Viewing 15 posts - 33,916 through 33,930 (of 49,552 total)