Viewing 15 posts - 46,576 through 46,590 (of 49,552 total)
It's very likely the checkpoint, which writes dirty pages to disk. The frequency that the checkpoint runs at depends on the frequency of changes to the database
It looks like you'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
May 13, 2008 at 5:05 am
gan_kim_heng (5/13/2008)
I also think about table partitioning in MSSQL 2005, by using date as partition
Why? What volumes of data are we talking here? Why kind of queries? How fast...
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
May 13, 2008 at 4:59 am
No, not really.
You said before you want 1 row per departure airport, the one with the cheapest price. Now you say "Any which the departure date is greater than...
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
May 13, 2008 at 4:55 am
Can you go into more detail on exactly what is slow in your current app. Selects? Inserts?
With a properly designed table, well-written SQL and optimal indexes, 10 million rows shouldn't...
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
May 13, 2008 at 4:48 am
Are you sure it's the plan generation that's taking the time? If the data returned by the view is not in the data cache, it has to be retrieved from...
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
May 13, 2008 at 4:34 am
Should do.
Which of those rows is the query supposed to return?
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
May 13, 2008 at 4:29 am
http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx
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
May 13, 2008 at 3:20 am
Neither. Put all the data into 1 table with a date 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
May 13, 2008 at 3:16 am
Perhaps start by reversing the string (REVERSE). From there it should be easy to get 2 delimiters into the string with CHARINDEX and it's optional StartPosition parameter.
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
May 13, 2008 at 2:21 am
IF EXISTS (SELECT 1 from master.dbo.sysobjects where name = 'Table1' and xtype = 'U')
BEGIN
-- do something here.
END
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
May 13, 2008 at 2:16 am
The index definitions please?
This is going to prevent index seeks on these two columns
AND ISNULL(C.col5,'')
AND ISNULL(TP.col5,'')
In addition, the kind of 'search-all' query that you have is quite well known...
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
May 13, 2008 at 1:07 am
Jeff Moden (5/13/2008)
Heh... can't wait for the mess folks are gonna make in 2k8 with the separate DATE and TIME datatypes...
Agreed. There are legit cases to store just one of...
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
May 13, 2008 at 12:55 am
Jeff Moden (5/12/2008)
A better question is why would anyone use a character based datatype to store a "Load time"?
And why one would want to store a data and a time...
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
May 13, 2008 at 12:48 am
Probably because the objects are not fully qualified. (dbo.usp...)
What's probably happening is that SQL's first looking for the object in the current user's default schema, not finding it, then looking...
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
May 13, 2008 at 12:36 am
Providing there are indexes appropriate for the query, yes
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
May 13, 2008 at 12:34 am
Viewing 15 posts - 46,576 through 46,590 (of 49,552 total)