Forum Replies Created
Viewing 15 posts - 3,211 through 3,225 (of 5,588 total)
-
RE: Inside the Optimizer: Constructing a Plan - Part 3
Awesome series Paul!
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 -
RE: Are the posted questions getting worse?
Steve Jones - Editor (9/14/2010)
Well I sent a note to our BIT friend and got a reply back. Apparently- he was abused
- I contributed to the abuser by pointing...
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 -
RE: Are the posted questions getting worse?
CirquedeSQLeil (9/14/2010)
AhhhSo I can bring my fat goats in here for people to see and watch?
Cool - here is my goat.
Do you really have a goat? We had 4 pygmy...
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 -
RE: increment string in vchar column
a.borgeld (9/14/2010)
In one word. Thank you for the lesson Wayne.When its al finished i will come back to this topic.
Kind regards,
André
No problem, I'm glad I can help. If you have...
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 -
RE: Adding and totaling duplicate data from a single column
pharmboy4u (9/14/2010)
CELKO (9/14/2010)
Please post DDL, so that people do not have to guess what the keys, constraints, Declarative Referential Integrity, data types, etc. in your schema are. Please learn 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 -
RE: How to change table owner when restoring database?
assh1122 (9/14/2010)
Hi,Thank you both for taking your time to answer my question. I could able to successfully change the table owner using the sp_changeobjectowner '[currentschema].[currenttable]' , 'dbo' command. Now I...
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 -
RE: Case Statement Help
Looks like I got in ahead of Lowell by 1 or 2 ms.
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 -
RE: Restoring a subset of data to a test server
Under this situation, my first thought is to use the Import wizard to import all of the tables you need from the main database, then import the others via 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 -
RE: Indexing and Primary Keys
The way it's written, yes. However, if you can make the PK be on (B, C, A), then you wouldn't need to.
Edit: also, the index on B,C isn't for just...
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 -
RE: Case Statement Help
You can only have one else condition for the case statement, after all of the WHEN conditions.
CASEWHEN Code Between 1 and 24 THEN Hours
WHEN Code Between 26 and 29...
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 -
RE: Are the posted questions getting worse?
CirquedeSQLeil (9/14/2010)
Steve Jones - Editor (9/14/2010)
I think when I was visiting Jason's home in Vegas this summer the Orange chip at the Bellagio was 25,000. Needless to say I just...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 -
RE: Are the posted questions getting worse?
Alvin Ramard (9/14/2010)
WayneS (9/14/2010)
Chad Crawford (9/14/2010)
Alvin Ramard (9/14/2010)
Chad Crawford (9/14/2010)
If only you and DEAD people can read Hex, how many people can read Hex?Ah darn! I ran...
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 -
RE: Are the posted questions getting worse?
Chad Crawford (9/14/2010)
Alvin Ramard (9/14/2010)
Chad Crawford (9/14/2010)
If only you and DEAD people can read Hex, how many people can read Hex?Ah darn! I ran out of fingers...
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 -
RE: Combining the use of ROWNUMBER() for paging, with a search result record set
Yep, two hits against a temp table (especially with an index) can be cheaper than two hits against a nasty CTE.
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 -
RE: select boolean resultvalue based on column value
petervdkerk (9/14/2010)
I have a table which has a column thumbid of type intI want to select if the column thumbid holds a value larger than 0.
If the column value...
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
Viewing 15 posts - 3,211 through 3,225 (of 5,588 total)