WayneS

Forum Replies Created

Viewing 15 posts - 3,151 through 3,165 (of 5,588 total)

RE: D: drive is full and transaction log is full

@Gail - just curious... how did you acquire this mountain of knowledge on disaster recovery of failed databases? Like I mentioned earlier, you're one of the best out there... 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

September 16, 2010 at 2:10 pm

#1222581
RE: Problem with Datetime

Is it possible that in one place you're using a datetime datatype (which will not accept the extra digits), and in the other you're using datetime2 (which will)?
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, 2010 at 1:58 pm

#1222567
RE: Basic TSQL Question. Need quick reply/suggestion

It seems like the CASE statement is what you're looking for.
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, 2010 at 1:12 pm

#1222521
RE: Winzip use in SSIS

You're sure you're running wzzip, and not winzip32?
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, 2010 at 1:09 pm

#1222518
RE: D: drive is full and transaction log is full

No, it won't help. (At least, not yet.)
Gail is one of the best at this (I can only think of one better)... please follow her advice to the letter.
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, 2010 at 12:28 pm

#1222487
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/16/2010)
So is Alvin still gonna get stoned? 😎
Everybody must!
Groan.....
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, 2010 at 11:57 am

#1222459
RE: Are the posted questions getting worse?

Alvin Ramard (9/16/2010)
I give up. How can I expect to win when I'm dealing with people that do not appreciate good humour? 😎
But we do appreciate good...
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, 2010 at 11:56 am

#1222456
RE: Are the posted questions getting worse?

jcrawf02 (9/16/2010)
So is Alvin still gonna get stoned? 😎
Rocks... or weed? 😀
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, 2010 at 11:54 am

#1222455
RE: Are the posted questions getting worse?

Dave Ballantyne (9/16/2010)
Its not all bad though...
http://www.sqlservercentral.com/Forums/Topic987019-1292-1.aspx
Two words: totally awesome!
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, 2010 at 11:42 am

#1222447
RE: What a nice place to be

Mike, thank you very much.
It's people like you that take the time to do things like this that makes us all realize why we do all we do for...
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, 2010 at 11:42 am

#1222446
RE: Are the posted questions getting worse?

GilaMonster (9/16/2010)
Combine this and the BIT thread and I'm just about ready to throw in the towel.
http://www.sqlservercentral.com/Forums/FindPost986824.aspx
But Gail, you know that there are so many other people that truly appreciate...
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, 2010 at 1:28 am

#1221954
RE: Are the posted questions getting worse?

status report: we need 20.3 posts/day to reach 20k by the 2yr anniversary of this post (11.18.2010).
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, 2010 at 12:53 am

#1221933
RE: We Are Not Alone

I didn't know about SQL-Lunch. Thanks!
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, 2010 at 12:48 am

#1221931
RE: What are MSSQL DBA Lines

Historically, I've seen two major divisions:
1. Production support - these folks start caring about things from the database level up... they are concerned with performance, backups, hardware, jobs, etc. 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

September 16, 2010 at 12:45 am

#1221927
RE: Does SSRS, IS, AS come with SQL Server 2008 R2 standard edition

Check out this link.
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, 2010 at 12:38 am

#1221922

Viewing 15 posts - 3,151 through 3,165 (of 5,588 total)