WayneS

Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 5,588 total)

RE: Are the posted questions getting worse?

jcrawf02 (4/12/2010)
At least I found SSC. Learned more about SQL ....
You talkin 'bout me? :w00t:
Seriously, this is so true. I've been developing against SQL since 6.5, but I've learned more...
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 12, 2010 at 3:08 pm

#1150381
RE: How To Execute Procedure At Server Shutdown

This doesn't answer your question, but maybe it will help with the underlying issue.
Since you want to capture the data from the dmv, while not capture the data periodically (say,...
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 12, 2010 at 2:45 pm

#1150373
RE: Are the posted questions getting worse?

Tammy,
WELCOME!!! You might be a newbie, but it looks like you've got the right attitude to deal with your issues.
As it so happens, you've stumbled upon our "water-cooler" thread, where...
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 12, 2010 at 2:20 pm

#1150343
RE: How to view in web page mhtml files exported from Reporting Services in FireFox?

Luke L (4/12/2010)
I know there are issues with FF and reports generated from SSRS in general, so I would imagine some of the suggestions on how to correct them in...
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 12, 2010 at 2:06 pm

#1150323
RE: Are the posted questions getting worse?

jcrawf02 (4/12/2010)
CirquedeSQLeil (4/12/2010)
The ability to raise kids is akin to the ability to write high performing tsql - thus the Thread is an excellent source for how to raise your...
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 12, 2010 at 12:57 pm

#1150274
RE: Are the posted questions getting worse?

CirquedeSQLeil (4/12/2010)
The ability to raise kids is akin to the ability to write high performing tsql - thus the Thread is an excellent source for how to raise your children.
If...
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 12, 2010 at 12:56 pm

#1150272
RE: Are the posted questions getting worse?

Roy Ernest (4/12/2010)
... Hope the THREAD behaved.. 🙂
Well, not really. An invader came and attacked many on the thread. If the attacker comes back, it seems the best solution 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

April 12, 2010 at 9:53 am

#1150138
RE: Are the posted questions getting worse?

Roy Ernest (4/12/2010)
I am back from my vacation... And I am not even going to bother trying to catch up with thread... It will take the next two weeks 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 12, 2010 at 9:03 am

#1150115
RE: Understanding and Using APPLY (Part 1)

BTW Paul, I really like the way you did the data diagram with grids under the tables (so much that I'll probably utilize that technique in any future articles 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

April 12, 2010 at 8:59 am

#1150113
RE: Understanding and Using APPLY (Part 1)

Paul,
Most excellent! This has been bookmarked, and I'm also looking forward to Part II
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 12, 2010 at 7:01 am

#1150008
RE: Comparing Table Variables with Temporary Tables

kajalchatterjee (4/10/2010)
Well Wayne, it works perfectly in my local sqlserver (home computer) but it does not work in server at my office.
At my office when i ran the code...
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 11, 2010 at 5:36 am

#1149701
RE: MCJ - The Missing Link

I talked this up a little bit at the SQL Saturday in Richmond yesterday. Had an interesting talk with Andy Leonard, and he is really interested in the MCJ. He...
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 11, 2010 at 5:30 am

#1149700
RE: Recursive cross join to get all available combinaisons

Ninja's_RGR'us (4/10/2010)
Wow that's fast... under 3 secs on our prod server.
Only 3 more secs to shave off boys ! 😉
If my math skills are anywhere near where I think they...
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 10, 2010 at 5:52 pm

#1149653
RE: Comparing Table Variables with Temporary Tables

T Norton (4/9/2010)
Very well done..!!!
This article clearly articulates and validates what I've been preaching to my team for years.
Thanks for doing this…! 😀
You're welcome! And thanks for the accolades.
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 10, 2010 at 5:28 pm

#1149652
RE: Comparing Table Variables with Temporary Tables

kajalchatterjee (4/9/2010)
Comparing Table Variables with Temporary Tables
I ran the following piece of code in SQL-Server 2005 and i can not see any entry of table variable in tempdb database. 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

April 10, 2010 at 5:27 pm

#1149651

Viewing 15 posts - 4,456 through 4,470 (of 5,588 total)