Viewing 15 posts - 46,486 through 46,500 (of 49,552 total)
Sandy (5/20/2008)
If I am using the GETDATE() function, Its using Server Side Code to get the functionally of this function which is calling as delegates in .NET.
Um.... Getdate is not...
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 20, 2008 at 5:49 am
As insert statemetns would be easier, as it's gonna take time to manually enter the data into the table.
No matter. I do prefer to test before posting though.
Give this select...
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 20, 2008 at 5:46 am
Johan, if you can give me the table definition and the sample data as insert statements, I'll have a solution for you before you and Sandy stop arguing. 😉
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 20, 2008 at 5:41 am
karthikeyan (5/20/2008)
As for higher vs lower reads, which do you think is better, for SQL to read 1782 pages or for it to read 720?
1782 is better. Am 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
May 20, 2008 at 5:40 am
Sandy (5/20/2008)
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 20, 2008 at 5:38 am
What do you mean, "The trace won't enter the job step"?
Set the trace definition once, thenset the job to change the status of the trace, start and pause it. Should...
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 20, 2008 at 5:34 am
Could you give the table definition please and, if possible, the sample input as insert statements.
Just to make sure, you are using SQL 2005? If so, this looks like something...
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 20, 2008 at 5:31 am
Forget the inequlity, all those functions on columns in there where clause mean you are going to get scans. (not that you have an index on StartDate that SQL could...
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 20, 2008 at 5:28 am
Is there a trigger on the table?
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 20, 2008 at 5:19 am
A while loop is not going to be massivly more efficient. It's still row-by-row processing of a large number of rows.
Johann, can you give us sample input and output please,...
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 20, 2008 at 5:19 am
Sure. You can get profiler to create you a script that defines the trace.
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 20, 2008 at 5:15 am
Databases only have 1 mdf file. They can have multiple ndf files (secondary data files)
Could you explain a bit more what you're trying to do? I'm not sure that 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
May 20, 2008 at 2:55 am
mark (5/20/2008)
So on that note are you able to tell me if it is "Best Pratice" to have a clustered index on a table? (as opposed...
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 20, 2008 at 12:59 am
Look up the REPLACE function in books online.
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 20, 2008 at 12:38 am
Lots of info on SQL 2008:
http://www.microsoft.com/sqlserver/2008/en/us/default.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 20, 2008 at 12:36 am
Viewing 15 posts - 46,486 through 46,500 (of 49,552 total)