WayneS

Forum Replies Created

Viewing 15 posts - 3,691 through 3,705 (of 5,588 total)

RE: T-SQL only Solution for gathering disk size info?

Jeff, you might be able to use this article[/url] to do it.
Also, can you get this information if you were to use xp_cmdshell? You could enable/disable that just like...
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 5, 2010 at 8:07 pm

#1203222
RE: Are the posted questions getting worse?

Lynn Pettis (8/5/2010)
Well, getting really short here, tomorrow is my last day with my current employer!
Wish me luck!!
Good Luck in them letting you actually leave! :crying:
Seriously, best of luck 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

August 5, 2010 at 5:16 pm

#1203187
RE: T-SQL only Solution for gathering disk size info?

Thanks for the update Jeff.
In 2008, you should be able to use PowerShell to get the data you need.
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 5, 2010 at 5:07 pm

#1203183
RE: Variable Month Query

Ricardumus (8/5/2010)
I just didn't understand the CTE (N). Not sure what that is. 🙂
A "CTE" (Common-Table-Expression) is essentially a pre-defined sub-query. It starts with the keyword "WITH", followed by 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

August 5, 2010 at 1:47 pm

#1203111
RE: Variable Month Query

Ricardumus (8/4/2010)
Wow, that looks awesome.
What does it do? lol
Honestly you blasted way past me with your SQL knowledge. You went to the moon and
im still stuck in Rhode...
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 5, 2010 at 12:30 pm

#1203042
RE: T-SQL only Solution for gathering disk size info?

jeff.mason (8/5/2010)
Don't have a ton of experience mapping COM object to VBScripts, so at first I am not sure how to do this with the OA procs, but you don't...
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 5, 2010 at 12:27 pm

#1203038
RE: delete with cursor

Jaime E. Maccou (8/5/2010)
...please note or make any suggestion for improvement.
How about simply:
execute sp_MSforeachdb 'IF ''?'' NOT IN (''model'',''master'',''msdb'',''tempdb'',''ReportServer'',''ReportServerTempDB'') BEGIN PRINT ''Checking Database ?'';DELETE FROM [?].dbo.WORKLISTLOG;END;'
Note: those are all single-quotes...
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 5, 2010 at 11:45 am

#1203006
RE: Changing Colour of QA to differentiate between Prod and Test

@Lowell: while you're in a learning mode, did you know that you can add "Places" to your SSMS open/save dialogs?
For SQL 2008 (for 2005, substitute 90 for 100 below):
Windows Registry...
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 5, 2010 at 11:38 am

#1203000
RE: How do you do RBAR - Record Sets

Sounds like a dynamic cross-tab / pivot. See the two articles in my signature (Parts 1 and 2) - part 2 covers a dynamic cross-tab.
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 5, 2010 at 11:32 am

#1202992
RE: T-SQL only Solution for gathering disk size info?

Can you get the mount point information from VBSCRIPT? If so, then you should be able to just expand upon what is already there with the sp_OA calls. I've never...
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 5, 2010 at 11:30 am

#1202991
RE: Rolling 3 Weeks

Back to the original question...
How does this work for you? (It might need some adjustment if running on a Sunday, but you should be able to work that out. 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

August 5, 2010 at 11:27 am

#1202985
RE: Changing Colour of QA to differentiate between Prod and Test

Lowell (8/5/2010)
WayneS (8/5/2010)
If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.
If it's 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 5, 2010 at 11:02 am

#1202961
RE: T-SQL only Solution for gathering disk size info?

Not sure if this will get the mount points. This method requires ole automation be on. It turns it on, and then returns it to it's original setting when finished.
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

August 5, 2010 at 9:21 am

#1202845
RE: Changing Colour of QA to differentiate between Prod and Test

If it's a registered server, right-click server and select properties. Go to the connection properties tab. Check the "Use Custom Color" checkbox, and select the color.
If it's a server 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

August 5, 2010 at 9:15 am

#1202840
RE: Compare data between two tables

check out the EXCEPT and INTERSECT operators:
select <columnlist> from table1
EXCEPT
select <columnlist> from table2
will show you what's in table1 but not in table2
replacing EXCEPT with INTERSECT will show you what 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

August 5, 2010 at 8:35 am

#1202804

Viewing 15 posts - 3,691 through 3,705 (of 5,588 total)