Viewing 15 posts - 1,426 through 1,440 (of 7,636 total)
Jeff Moden (10/9/2009)
Look closely... he didn't say INDEX(1)... he said INDEX = 1 and the clustered index is always #1. Take a look at BOL...
If a clustered index exists,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 10, 2009 at 11:51 am
Hint: XML.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 9, 2009 at 8:56 pm
Here's the SQL 2005 version:
select [name], is_disabled from sys.triggers
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 9, 2009 at 7:28 pm
Funny, I still haven't gotten anything. Odd. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 9, 2009 at 6:54 pm
No, you cannot use a stored procedure in a view.
However, what you can do is to create a table and then use INSERT..EXEC to dump the results or your stored...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 9, 2009 at 5:52 pm
Steve Jones - Editor (10/9/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 9, 2009 at 5:22 pm
You can also very easily control something like this from the DTExec command line (or SQL Agent Job Step definition), either through the command line options, or through package configurations...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 8, 2009 at 11:51 pm
Matt Wilhoite (10/7/2009)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 8, 2009 at 11:37 pm
Oh and yes, Template Packages are also a huge help.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 8, 2009 at 11:20 pm
My experience also is that "Don't Save Sensitive.." and relying on Trusted Connections is by far the easiest way to do shared development.
Other crucial aspects facilitating successful collaborative development in...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 8, 2009 at 11:19 pm
Here's a start:
DECLARE @sql AS NVARCHAR(MAX)
SELECT @sql = VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'YourViewName'
UNION SELECT * FROM SLS_CURRENT_MONTH'
BEGIN TRANSACTION
BEGIN TRY
DROP...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 8, 2009 at 10:44 pm
Dave Ballantyne (10/8/2009)
Grant Fritchey (10/8/2009)
Hammmer. That's the answer. A good hammer will fix or replace just about anything.
Must of skipped over that chapter in your book.
It was one of those...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 8, 2009 at 7:56 pm
RBarryYoung (10/8/2009)
GilaMonster (10/8/2009)
Using an inequality character
SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50
Using escape codes for inequality
SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50
Using angle brackets to designate a placeholder
USE...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 8, 2009 at 6:55 pm
GilaMonster (10/8/2009)
Using an inequality character
SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50
Using escape codes for inequality
SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50
Using angle brackets to designate a placeholder
USE <Database...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 8, 2009 at 6:49 pm
Lowell (10/7/2009)
RBarryYoung (10/7/2009)
The problem is that the SQL Server maintained Dependency information in SQL Server 2000 and 2005 is not itself dependable.
i thought the dependancy issue was only (potentially) inaccurate...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 7, 2009 at 9:51 pm
Viewing 15 posts - 1,426 through 1,440 (of 7,636 total)