Viewing 15 posts - 28,336 through 28,350 (of 49,552 total)
The costs are estimates. There are a number of things that can make them wrong, out of date stats and associated incorrect row estimations is the big one.
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 19, 2011 at 11:31 am
Brandie Tarvin (1/19/2011)
EDIT: I ask because I've never seen unique(id) as proper column name before. It looks more like a function and I can't find a unique() command in BOL.
There...
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 19, 2011 at 11:26 am
Why do you want to? It's quite likely to be all over the file. All over multiple files if there's more than one file in the filegroup its in.
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 19, 2011 at 8:39 am
You didn't test any of that, did you? hint: the create table statements are going to fail with invalid data type errors. (if they don't on your database, you have...
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 19, 2011 at 8:33 am
bhushan.bagul (1/19/2011)
1. I click on "Include Actual Execution Plan'2. Ran SQL query
3. After query execution nothing was appeared so I click on "Display Estimated Execution Plan"
Then they are still estimated...
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 19, 2011 at 8:07 am
sql_butterfly (1/19/2011)
Well, it depends on a person's perspective (I feel :)).
Would you seriously consider writing single a C# function that did multiple different things?
However my point is whether its good...
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 19, 2011 at 7:58 am
Nope.
SQL supports the ACID requirements for relational databases. D stands for Durability. Once a transaction is committed, it is permanent, it cannot be lost due to power failures or anything...
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 19, 2011 at 7:56 am
Missing in what context?
What makes you think an index is missing?
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 19, 2011 at 7:21 am
Would you write a single function/procedure in C# (or whatever front-end language that you use) to do every single thing that a specific portion of the system can do?
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 19, 2011 at 7:20 am
No where near enough information to say anything meaningful. Expand 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
January 19, 2011 at 7:10 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1050023-1351-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
January 19, 2011 at 7:09 am
Not talking about anything fancy here, just select statements that have small enough ranges (probably of the clustered index) so that they don't hit the corruption. You will not be...
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 19, 2011 at 7:07 am
GilaMonster (1/19/2011)
Sample data in a form that it can be easily inserted. INSERT INTO ....
Not what your query currently returns, sample data from the...
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 19, 2011 at 6:43 am
I'm assuming you didn't read the article. Please do.
Table definition please - create table (....),
Sample data in a form that it can be easily inserted. INSERT INTO ....
Not what your...
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 19, 2011 at 6:11 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1049970-48-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
January 19, 2011 at 5:56 am
Viewing 15 posts - 28,336 through 28,350 (of 49,552 total)