Viewing 15 posts - 27,511 through 27,525 (of 49,552 total)
[Jim].[dba].[Murphy] (3/8/2011)
Right, the PK is already included in every NCI in a table with a clustered index, so the include is not needed/desired.
The clustered index key columns are included 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
March 8, 2011 at 7:44 am
Sure. Why would it not?
SQL's not stupid enough to add them twice if you explicitly specify them. Also, what happens if the clustered index is moved?
btw, it's the clustered...
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
March 8, 2011 at 7:42 am
[Jim].[dba].[Murphy] (3/8/2011)
Bulk log does not retain tlog history for certain bulk data modifications, like a reindex (and other cases). It does keep the full history for all non-bulk activity.
Er,...
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
March 8, 2011 at 7:38 am
May I suggest you read up on logging in Books Online?
Short answer: Every data change is logged. In both simple and bulk-logged recovery models, operations that qualify for minimal logging...
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
March 8, 2011 at 7:23 am
GSquared (3/8/2011)
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
March 8, 2011 at 7:01 am
Short answer: you can't.
If you are putting the database on the client's server then their DBAs have full control. On SQL 2008 you could use TDE, but that would...
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
March 8, 2011 at 6:56 am
Short answer: You can't.
If you are putting a database onto a client's machine, then their sysadmins can do anything to that database and there is no way you can prevent...
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
March 8, 2011 at 6:52 am
If you're talking a nonclustered index, typically approach 2. If you're talking a clustered index, it depends, I've seen both approaches work.
Best bet, try both, compare execution time, IOs, CPU...
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
March 8, 2011 at 6:50 am
soufya91 (3/8/2011)
i know the languages but infact i cannot organize gradually build it
Sorry, don't understand what you're saying.
I also don't understand what you're looking for. Development or administration? Designing...
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
March 8, 2011 at 4:35 am
soufya91 (3/8/2011)
please don't suggest me to read tutorials i want some one to be my teacher
How much are you willing to pay for teacher? Please remember we're all volunteers here,...
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
March 8, 2011 at 4:25 am
http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/
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
March 8, 2011 at 4:17 am
Microsoft isn't exactly going to send someone after you if you specify an old cert on a resume...
Certs don't expire, they just become inactive
I hold MCSD for Visual Studio 6....
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
March 7, 2011 at 2:53 pm
Rich Yarger (3/7/2011)
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
March 7, 2011 at 2:47 pm
Step 1: shoot your developers (self defence) :hehe: It's near impossible to do effective indexing when all queries are select *
Step 2: Show the reporting guy how to 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
March 7, 2011 at 1:52 pm
None of the above. You need to create indexes that support the queries. Only time an index with 12 columns is useful for a bunch of queries is if all...
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
March 7, 2011 at 1:23 pm
Viewing 15 posts - 27,511 through 27,525 (of 49,552 total)