Viewing 15 posts - 47,851 through 47,865 (of 49,552 total)
For the beginning and end of the day, week, month, quarter, year...
http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/%5B/url%5D
I've done the end of the intervals at 3ms before the beginning of the next (ie, end of today...
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
January 2, 2008 at 11:46 am
Kenneth Fisher (1/2/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
January 2, 2008 at 11:43 am
Good point. Thanks.
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
January 2, 2008 at 11:20 am
Use the sys.object view, rather than sysobjects. sys.objects has both a type and a type_description column, so you can see exactly what's what.
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
January 2, 2008 at 6:00 am
CTEs are nice for generating smallish amounts of data, but the max number of rows a recursive CTE can return (without using cross joins, union or while loop) is 32767....
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
January 2, 2008 at 5:14 am
MarkusB (1/2/2008)
which according to BOL means "Cumulative count of leaf-level page allocations in the index or heap. For an index, a page allocation corresponds 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
January 2, 2008 at 4:23 am
Thanks Markus. Will check that out.
Chirag: I'm not looking for the umber of pages in the index. That's easy. What I'm trying to get an idea of is how often...
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
January 2, 2008 at 4:04 am
You can read the contents of the system tables if you connect using the DAC. They're not that interesting and are quite hard to understand, since there's no documentation anywhere....
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
January 2, 2008 at 1:11 am
Joins done in the from are easier to read and reduce the chances of getting an unwanted cross join.
In addition, the old-style outer join syntax (Table1.Col1 *= Table2.Col1) 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
January 2, 2008 at 1:05 am
Add a column of type int (that's 1.4 million records you have. Int goes up to 2.1 billion) and set identity on.
Edit: And if you do expect more than 2.1...
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
January 2, 2008 at 1:02 am
Ziljan4 (1/2/2008)
What would be your first instinct when you see log file growing, and how do you usually handle it?
Check my tran log backups, make sure they are 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
January 2, 2008 at 12:59 am
Matt Miller (1/1/2008)
You must have slept through that part of the 431 prep...:)
OK, I will admit I didn't do the 431 training. Did do all of the SQL developer training...
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
January 1, 2008 at 11:59 pm
Have you tried them?
Run them both with the execution plan enabled and see which SQL says has the higher cost. See which (if either) runs faster, and see which (if...
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
January 1, 2008 at 11:30 pm
Jeff Moden (1/1/2008)
what a "Triangular Join" actually is? They just don't teach the good stuff in the schools that are supposed to...
I haven't seen a course that...
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
January 1, 2008 at 1:55 pm
In doesn't work with a variable that contains a comma-delimited field. Your best option would be to split up the string with a table-valued function then use IN (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
January 1, 2008 at 11:42 am
Viewing 15 posts - 47,851 through 47,865 (of 49,552 total)