Viewing 15 posts - 35,206 through 35,220 (of 49,552 total)
skhan-680833 (12/18/2009)
but is it possible to do teh create index in a way so that it ignores the blank spaces?
What do you mean? What blank spaces where?
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
December 18, 2009 at 10:52 am
What precisely do you mean by "columns with space"?
Columns with lots of nulls?
Columns with lots of empty strings?
Columns that have varchar/nvarchar with leading/trailing spaces?
Something else?
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
December 18, 2009 at 10:25 am
jnaranjo86 (12/18/2009)
Anywho, what I am doing is, imo, almost clearly explained in the first post.
If that's clearly explained, I don't want to see what you call a 'brief summary' ;-)....
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
December 18, 2009 at 10:24 am
This is a difficult one and, to be honest, I'm not overly fond of either.
The first, often called Entity-Attribute-Value is not a particularly good design most of the time. 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
December 18, 2009 at 9:16 am
lakb200 (12/18/2009)
Cannot define as date time.
Why 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
December 18, 2009 at 9:03 am
Itanium, because someone at Redgate won the lottery. 😉
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
December 18, 2009 at 8:44 am
lakb200 (12/18/2009)
autostats is turned on. How would you know which stats are USELESS and could be dropped?
If they are automatically created statistics then, virtually by definition, they are 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
December 18, 2009 at 8:43 am
GilaMonster (12/18/2009)
If that doesn't work, post the error messages and check what's in the SQL error log.
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
December 18, 2009 at 8:41 am
Good thing that you're not running SQL 2000 (at least I assume you're not) or that could have done nasty things to the database. If you are using SQL 2000,...
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
December 18, 2009 at 6:51 am
Can you save the plan as a .sqlplan file? While I can read the xml, it's tedious.
Are there more rows that have type=4 than for the others?
Does an UPDATE...
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
December 18, 2009 at 3:46 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic836109-1550-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
December 18, 2009 at 1:02 am
Not quite sure I understand your question. You can use profiler to see what a stats update job is running and how long the various steps take.
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
December 18, 2009 at 1:01 am
lakb200 (12/17/2009)
can you partition onnvarchar column with values mm/dd/yyyy.
Wait just a sec. An nvarchar column with a date in it? Why nvarchar and not datetime? If it's a date,...
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
December 18, 2009 at 12:59 am
SQL 2005/2008
IF EXISTS (SELECT 1 FROM sys.databases WHERE name = <database name>)
-- database exists
SQL 2000
IF EXISTS (SELECT 1 FROM sysdatabases WHERE name = <database name>)
-- database...
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
December 18, 2009 at 12:59 am
Depends.
Do you just want a copy of the database on the dev box? If so, just the full's fine. If you want the opy on the dev box to reflect...
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
December 17, 2009 at 2:25 pm
Viewing 15 posts - 35,206 through 35,220 (of 49,552 total)