WayneS

Forum Replies Created

Viewing 15 posts - 1,036 through 1,050 (of 5,588 total)

RE: Are the posted questions getting worse?

GilaMonster (9/16/2011)
bitbucket-25253 (9/16/2011)
Might I add that a brief description of what the CHECKPOINT command actual accomplishes. I believe many do not understand that it writes changes in the Buffer...
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

September 16, 2011 at 7:57 pm

#1382856
RE: Are the posted questions getting worse?

Gianluca Sartori (9/16/2011)
WayneS (9/16/2011)
Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm...
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

September 16, 2011 at 4:16 pm

#1382817
RE: Are the posted questions getting worse?

Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight, but I'm not completely happy...
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

September 16, 2011 at 8:17 am

#1382570
RE: Are the posted questions getting worse?

SQLRNNR (9/15/2011)
Just saying that we only need 98 more posts for 30,000
how many?
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

September 15, 2011 at 10:41 am

#1382136
RE: sql Cardinality

I like that parking garage analogy Gus. Good going.
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

September 15, 2011 at 10:04 am

#1382096
RE: Are the posted questions getting worse?

ALZDBA (9/14/2011)
We get to hear "Ho, ho, hoo" at SQLPASS 2011 !!!!
http://www.sqlservercentral.com/articles/Exceptional+DBA+Awards/75988/
Congratulations Jeff !!
:w00t::w00t::w00t::w00t::w00t:
Congrats Jeff. I can't think of a better person than you for this.
Thank you for, well, being...
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

September 14, 2011 at 7:29 am

#1381287
RE: Cursor Causing Performance Issues

@sqlsatyam
Okay, the balls in your court. There are two guys here that have stated that they believe this will run in under a minute. All we need is sample data......
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

September 12, 2011 at 8:05 pm

#1380395
RE: Are the posted questions getting worse?

Chad Crawford (9/12/2011)
Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>, since the topic 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

September 12, 2011 at 7:59 pm

#1380391
RE: Cursor Causing Performance Issues

😀
Edit: which now makes absolutely no sense due to a prior message being altered. Oh well...
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

September 12, 2011 at 3:49 am

#1379854
RE: Cursor Causing Performance Issues

sqlsatyam (9/11/2011)
Thanks to everyone who replied to my post.... Feels good to be in the community where experts are ready to help out....
I think that you'll find a lot of...
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

September 11, 2011 at 6:31 pm

#1379757
RE: Are the posted questions getting worse?

Ninja's_RGR'us (9/11/2011)
You want lousy week-end?
Try having 2K+ of unexpected repair on your car, having to lose 1 weeks income + all the trouble to be flooded by Irene while getting...
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

September 11, 2011 at 6:16 pm

#1379755
RE: Are the posted questions getting worse?

ALZDBA (9/11/2011)
:sig:
The one who's name thow shall not state felt the need to kill a forum newbe with ancient history and lousy advise.
http://www.sqlservercentral.com/Forums/FindPost1173017.aspx
The last sentence says it all about his...
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

September 11, 2011 at 6:44 am

#1379681
RE: Cursor Causing Performance Issues

sqlsatyam
I'd have to agree with Gail, Jeff and Johan - the problem is in your stored procedure. I'd go even further and say that the procedure was written to accept...
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

September 11, 2011 at 6:05 am

#1379679
RE: best book for sql server

nikk_Stone (9/10/2011)
thnx...
but the book which you have told me...it is not free of cost...
i have to buy it online...
i want a frre book
Well, do you want the BEST book, or...
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

September 10, 2011 at 1:32 pm

#1379623
RE: Are the posted questions getting worse?

Well, I'm just looking forward to seeing this precon (if I can just get it approved... boss is working on it... corporate stuff sucks...)
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

September 8, 2011 at 1:09 pm

#1378866

Viewing 15 posts - 1,036 through 1,050 (of 5,588 total)