WayneS

Forum Replies Created

Viewing 15 posts - 3,481 through 3,495 (of 5,588 total)

RE: script out database users for the selected database

If you're talking about actually performing a database restore, then your biggest issue isn't the GRANT permissions. It's going to be missing/orphaned users.
Missing users is obvious. Orphaned users is 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

August 31, 2010 at 7:46 am

#1214295
RE: Can splitting a database to several databses improve performance.

George has some excellent thoughts on this. Further, I agree with Steve about having 3 databases only if you anticipate moving them to different servers in the future.
If your thoughts...
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

August 31, 2010 at 7:37 am

#1214282
RE: A little help with a query

Tom, it actually sounds like you really needed some Cold Coffee :w00t:
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

August 31, 2010 at 7:29 am

#1214270
RE: Are the posted questions getting worse?

GilaMonster (8/31/2010)
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀
ACK! We've been invaded! There's one of those...
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

August 31, 2010 at 7:20 am

#1214258
RE: HAVING without GROUP BY

Hugo,
Great question!
It's too bad that this latest post wasn't part of the explanation for the question though - it's beautiful.
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

August 31, 2010 at 7:14 am

#1214253
RE: Conditional WHERE Clauses and Boolean Algebra

For those that have read this far, I'd like to suggest that you read this blog[/url] by Gail Shaw on working with this type of query (catch-all query).
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

August 31, 2010 at 6:49 am

#1214222
RE: Trigger On Update

You could do a select count(*) from inserted within the trigger.
Alternatively, in the code running the update statement, look at @@rowcount.
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

August 30, 2010 at 9:34 pm

#1214026
RE: How to generate script for existing profile in Database Mail?

SQL ORACLE (8/30/2010)
Thank you so much WayneS!
Is it possible to generate the script from an existing profile?
I just wrote this script to get all of the database mail profiles 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

August 30, 2010 at 9:31 pm

#1214025
RE: How to generate script for existing profile in Database Mail?

SQL ORACLE (8/30/2010)
Thank you so much WayneS!
Is it possible to generate the script from an existing profile?
Not that I'm aware of. I'd like this also.
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

August 30, 2010 at 8:16 pm

#1214018
RE: How to create an user friendly excel file via SSIS?

SSIS will not do this automatically.
However, you can use a vb.net script task, excel automation, and set it all yourself. However, this would imply that you are running excel on...
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

August 30, 2010 at 7:51 pm

#1214014
RE: Join to table if date in range or no range exists

loki1049 (8/30/2010)
Doing it as you state would cause a record to be thrown away if it didnt have an associated protection factor start and end date associated with it.
No...
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

August 30, 2010 at 5:53 pm

#1214003
RE: Table Variable vs. Temp Table - errors?

Uncle Moki (8/30/2010)
I'm not sure if I can. Let me see if I can duplicate this problem with a simple example that doesn't disclose anything my company might get...
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

August 30, 2010 at 5:40 pm

#1214000
RE: Table Variable vs. Temp Table - errors?

I don't see anything here either. Can you post the CTE?
Edit: There might be an implicit conversion going on somewhere.
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

August 30, 2010 at 4:59 pm

#1213993
RE: Creating dynamic sql with sp_executesql

sqlgreenhand (8/30/2010)
Got it! Sir.
Thanks.
No problem. Glad that I could help.
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

August 30, 2010 at 4:57 pm

#1213992
RE: did you leave a secure job, what pushed you to move and how did you get on?

Steve Jones - Editor (8/30/2010)
Probably a separate thread, but what's the menial workload? What do you do on a regular basis? I'd post that elsewhere, and perhaps see if there's...
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

August 30, 2010 at 4:33 pm

#1213985

Viewing 15 posts - 3,481 through 3,495 (of 5,588 total)