Viewing 15 posts - 9,301 through 9,315 (of 19,560 total)
This article may be of help.
http://jasonbrimhall.info/2010/05/19/tablespace-update/
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 25, 2011 at 2:03 pm
You are 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 25, 2011 at 2:01 pm
See if this is of help
http://msdn.microsoft.com/en-us/library/ms144288(v=sql.90).aspx#SpecifyingAnalysisServicesInstances
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 25, 2011 at 1:49 pm
ubeauty (7/25/2011)
Thanks Roy, yep i've got a copy of Dev Edition suppose i'm just seeing the best way to get experience of log shipping, replication etc
IMHO - create several VMs...
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 25, 2011 at 1:44 pm
Trey Staker (7/25/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 25, 2011 at 1:39 pm
DB Diva (7/25/2011)
What if I needed to replace more then one field, ie. firstname and lastname?
Can you help me with...
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 25, 2011 at 1:38 pm
NP
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 25, 2011 at 1:25 pm
This tool is generally downloaded to a central server. Then this tool deploys the updates to the other servers. You would typically set up a schedule to do...
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 25, 2011 at 1:25 pm
Lowell (7/25/2011)
@vSurveyMessage = 'Recently we invited you to participate in a survey to help ' + [@vfirstname]'
then you'll need to do a...
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 25, 2011 at 1:22 pm
WSUS is a tool available for download. Updates to WSUS are far less frequent than other Microsoft products.
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 25, 2011 at 1:14 pm
I'm anxiously waiting to see both. I think it should be good.
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 25, 2011 at 1:13 pm
Can you provide sample data from this table along with table def so we can test and provide a more accurate solution?
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 25, 2011 at 1:12 pm
Lowell (7/25/2011)
select
db_name(database_id) As...
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 25, 2011 at 1:09 pm
Try this
SELECT DB_NAME(PS.database_id) AS DBName,OBJECT_NAME(PS.object_id) AS TableName,PS.*
FROM sys.dm_db_index_physical_stats
(DB_ID(), null, NULL, NULL , 'DETAILED') PS
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 25, 2011 at 1:09 pm
I have been in environments where it has been both ways. It works to have either the net admins or the DBAs do that task.
We liked using WSUS in...
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 25, 2011 at 1:02 pm
Viewing 15 posts - 9,301 through 9,315 (of 19,560 total)