WayneS

Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 5,588 total)

RE: Columns that contain both clustered and unclustered

The optimizer would utilize the smaller index, since it knows it would have less disk IO to get the necessary information... and we all know that disk IO is THE...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 10:08 am

#1152260
RE: How to tune/speed up a procedure

Yep, good set-based code has this weird ability to usually run insanely fast. Glad you're learning (which is why we throw links at you instead of just telling you ......
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 10:03 am

#1152250
RE: performance question

ucbus 92278 (4/15/2010)
GSquared:
Thanks
You might also need to check if it's okay to post code online, since some companies don't allow that.
No my company does not allow. Also it is too...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 9:53 am

#1152236
RE: performance question

ucbus 92278 (4/15/2010)
. It might come down to checking the execution plan for this query... the query and/or indexes might need tweaking, and this could be causing the query to...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 9:43 am

#1152227
RE: performance question

ucbus 92278 (4/15/2010)
Look at Books Online a.k.a. BOL in the SQL Server box - that will be your primary source of documentation.
Thanks Pablo, are these availabe on Web?
Yes, at...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 9:34 am

#1152219
RE: How to: Rename foreign key constraint

You can also right-click the constraint (in SSMS), and select rename and do it there.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 9:28 am

#1152214
RE: Columns that contain both clustered and unclustered

Roy, I'm sorry I wasn't clearer the first time around.:(
Not entirely sure what you're meaning with the not so common cases. You really shouldn't have a non-clustered index on the...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 9:25 am

#1152211
RE: Are the posted questions getting worse?

Alvin Ramard (4/15/2010)
CirquedeSQLeil (4/15/2010)
Steve Jones - Editor (4/15/2010)
Happy Tax Day, and behave children. I'm going skiing, so no one will be here to moderate bad jokes and subtract points.
Which mtn...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 9:18 am

#1152204
RE: Columns that contain both clustered and unclustered

Yes, I knew that. Everything I wrote applies with that concept.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 9:01 am

#1152187
RE: Moving Databases

GSquared (4/15/2010)
I'm setting up to move all the databases from an existing SQL 2008 Standard 32-bit server to an SQL Server Enterprise 64-bit server.
So far I've: ...
reset the server name...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 8:55 am

#1152181
RE: performance question

ucbus 92278 (4/15/2010)
Our application uses a Stored procedure which formats an XML from the data retrieving from some 16 tables. The tables are hierarchial ( Parent-child-grandchild) with a single key...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 8:48 am

#1152178
RE: Columns that contain both clustered and unclustered

Keep in mind that a clustered index IS the table, physically sorted by the key(s) of the index. A non-clustered index is just the key(s) of the index, and a...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 8:33 am

#1152157
RE: Maximum Date

You're pretty close. Check out GROUP BY in BOL.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 8:09 am

#1152139
RE: Apostrophe's and Variables Headache

Paul Clark-418949 (4/15/2010)
PICNIC (Problem In Chair Not In Computer)...
I've heard it called BKAC (Between Keyboard and Chair), and ID-Ten-T (ID10T). 🙂
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 8:06 am

#1152135
RE: Stored procedure fine tuning steps/guidelines

You might also want to look at these e-books available here:
SQL Server Maintenance Plans by Brad McGehee[/url]
Mastering SQL Server Profiler by Brad McGehee
SQL Server Execution Plans by Grant Fritchey
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

April 15, 2010 at 7:58 am

#1152129

Viewing 15 posts - 4,396 through 4,410 (of 5,588 total)