Viewing 15 posts - 9,436 through 9,450 (of 19,560 total)
nice question.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2011 at 11:27 am
pipe
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2011 at 11:15 am
GSquared (7/11/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2011 at 11:09 am
Welsh Corgi (7/10/2011)
Someone ask me if Kaplan's Self Test Software and Transender violate the NDA?Your input is greatly appreciated.
I would dare say they appear to but Microsoft does not think...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 11, 2011 at 9:40 am
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 5:11 pm
This should work for you
Declare @asofDate Date = '1/1/2011'
;
With accesslevel as (
Select Custid,AccessLevel,DateTimeChanged
,rowid = ROW_NUMBER() over (PARTITION by custid order by datetimechanged desc)
From #Customers
Where DateTimeChanged <= @asofDate
)
Select Custid,AccessLevel,DateTimeChanged
From accesslevel
Where rowid...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 4:48 pm
First make sure there are no more connections being made to the database.
Then shut down the service.
Then go ahead and shut down the server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 4:40 pm
Copy the files from that location to any location you wish. You will then need to attach those files inside of SSMS.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 12:51 pm
You can query the sys.sql_expression_dependencies catalog view.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 11:15 am
Sessions refers to users connected during that time-frame to the database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 11:05 am
There is an object (in the db you are scripting) that is referencing an object in that other database. That reference creates a dependency and the user scripting this...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 11:03 am
Brandie Tarvin (7/8/2011)
crookj (7/8/2011)
SQLRNNR (7/8/2011)
Brandie Tarvin (7/8/2011)
SQLRNNR (7/8/2011)
STUMPEDFloured.
Tarred
Feathered
Boa
Constrictor
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 10:48 am
\Program Files\Microsoft SQL Server\MSSQL10.<InstanceID>\
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 10:45 am
Brandie Tarvin (7/8/2011)
SQLRNNR (7/8/2011)
STUMPEDFloured.
Tarred
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 10:42 am
Elliott Whitlow (7/8/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 10:33 am
Viewing 15 posts - 9,436 through 9,450 (of 19,560 total)