Viewing 15 posts - 9,811 through 9,825 (of 19,560 total)
forsqlserver (6/8/2011)
But u can use the secondary database as reporting database.
Yes, there would be some benefit there.
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
June 8, 2011 at 9:48 am
rfr.ferrari (6/8/2011)
but, with relation the High Availability, forget!!! if my server catch a fire or explode!!!😀
I would say more in regards to DR than HA. In a test environment,...
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
June 8, 2011 at 9:47 am
respirator
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
June 8, 2011 at 9:41 am
Yeah - that could make a difference. Let us know how it goes.
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
June 8, 2011 at 9:39 am
Good point sqlzealot. Teaching yourself is very effective - so long as you follow through and ensure you practice what you read.
This site is most excellent for learning new...
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
June 8, 2011 at 9:38 am
Most excellent. Glad it works.
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
June 8, 2011 at 9:36 am
While working on that, please check the last script I posted and see if that works.
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
June 7, 2011 at 5:32 pm
kwoznica (6/7/2011)
PaulB-TheOneAndOnly (6/7/2011)
kwoznica (6/7/2011)
Or does the application code need to...
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
June 7, 2011 at 5:24 pm
I read through your notes in the script and think I may have something that will work.
WITH timeframes AS
(SELECT es.id, es.date_time StartTime,EE.date_time AS EndTime
FROM events ES
CROSS APPLY (SELECT PK,id, date_time...
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
June 7, 2011 at 5:22 pm
eyejay (6/7/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
June 7, 2011 at 4:44 pm
I know you probably tried this but to confirm. Have you tried to create the proxy account to appease the system?
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
June 7, 2011 at 4:28 pm
Try this
Go into Project Properties, Debugging, and setting Run64BitRuntime to false.
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
June 7, 2011 at 4:09 pm
A transactional database is one that participates in updates, inserts, deletes of records. This can be in any of the recovery models.
There is a different topic of replication that...
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
June 7, 2011 at 4:08 pm
jcrawf02 (6/7/2011)
Grant Fritchey (6/7/2011)
Jim Murphy (6/7/2011)
Grant Fritchey (6/7/2011)
WayneS (6/6/2011)
If I've read things right, you're going to the Summit? Do you know that Thursdays up there is "Kilt Day"? Grant started...
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
June 7, 2011 at 4:05 pm
SSMS - is that when you are trying to open the package from SSMS on the server or on your workstation? If workstation, what version of SSMS are you...
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
June 7, 2011 at 2:41 pm
Viewing 15 posts - 9,811 through 9,825 (of 19,560 total)