WayneS

Forum Replies Created

Viewing 15 posts - 3,751 through 3,765 (of 5,588 total)

RE: Index Types

cengland0 (7/22/2010)
WayneS (7/22/2010)
For everyone that thinks that the BOL reference in the QotD is wrong and that there are just 5 types of indexes: I created a connect item 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

July 23, 2010 at 5:07 am

#1197430
RE: top 5th to 10 th record of a table

You've been asked to provide some DDL and sample data. Since all we have is a generic problem, here is a generic solution.
;WITH CTE AS
(
SELECT *,
...
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

July 23, 2010 at 4:57 am

#1197425
RE: Reading Deadlock Trace

Kwisatz78 (7/21/2010)
Oh wow I was just looking at some of your code on another post 🙂 it makes it much easier to read thanks.
I do have some niggly questions...
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

July 22, 2010 at 7:20 pm

#1197295
RE: Reading Deadlock Trace

doobya (7/21/2010)
wayne: that is very handy bit of sql
:blush: Thanks. It's been very handy for me also.
it is impossible / unreasonable and unnecessary to stop all deadlocks
It depends on what...
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

July 22, 2010 at 6:30 pm

#1197292
RE: Deadlock graph help

Take the deadlock graph xml, and put it into the variable in this code below, and run. It will show you lots of information about the deadlock.
declare @deadlock xml
set @deadlock...
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

July 22, 2010 at 6:26 pm

#1197291
RE: Sum Daily Data Into Weekly Data

First, thank you for posting the table DDL and expected output.
Second, it would really help if you were to actually post insert statements for your data. Please read the article...
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

July 22, 2010 at 6:21 pm

#1197288
RE: Any Service Pack released for SQL Server 2008 R2?

It just shipped like what, 2 months ago? It's a wee bit premature to be looking for one anytime soon.
I believe that it typically takes 9 mos or longer...
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

July 22, 2010 at 5:58 pm

#1197280
RE: Are the posted questions getting worse?

WayneS (7/22/2010)
Grant Fritchey (7/22/2010)
WayneS (7/22/2010)
How does one go about creating a connect item? I think I've got about a dozen to submit on indexes.....
It's not hard. Go to connect.microsoft.com and...
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

July 22, 2010 at 5:44 pm

#1197278
RE: Index Types

For everyone that thinks that the BOL reference in the QotD is wrong and that there are just 5 types of indexes: I created a connect item at https://connect.microsoft.com/SQLServer/feedback/details/577460/documentation-types-of-indexes 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

July 22, 2010 at 5:13 pm

#1197270
RE: Are the posted questions getting worse?

Grant Fritchey (7/22/2010)
WayneS (7/22/2010)
How does one go about creating a connect item? I think I've got about a dozen to submit on indexes.....
It's not hard. Go to connect.microsoft.com and follow...
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

July 22, 2010 at 1:50 pm

#1197160
RE: Are the posted questions getting worse?

GilaMonster (7/22/2010)
WayneS (7/22/2010)
Two questions about this list:
1. Isn't HEAP a characteristic of the table, meaning that the table has no index?
2. Where is full-text index?
As mentioned to Paul, HEAP is...
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

July 22, 2010 at 12:19 pm

#1197083
RE: Are the posted questions getting worse?

GilaMonster (7/22/2010)
Paul White NZ (7/22/2010)
A primary XML index is clearly different from a clustered index...right?
Yes it is, because it can only be defined on an XML column, because it doesn't...
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

July 22, 2010 at 12:17 pm

#1197079
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/22/2010)
I tend to agree with you, Gail, but a reference is a reference for purposes of discussion.
I do think this is a thorny issue. Would welcome...
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

July 22, 2010 at 12:02 pm

#1197060
RE: Are the posted questions getting worse?

GilaMonster (7/22/2010)
Jack Corbett (7/22/2010)
I got the answer right because of Grant's recent SQL University blog post[/url] which also lists 8 and references BOL.
I must admit, I don't agree with that....
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

July 22, 2010 at 11:59 am

#1197057
RE: Are the posted questions getting worse?

I've got a QotD question for you'll...
Is it sufficient to base the answer off of BOL?
I'm getting a lot of grief today over a few index types that people are...
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

July 22, 2010 at 10:39 am

#1196996

Viewing 15 posts - 3,751 through 3,765 (of 5,588 total)