Viewing 15 posts - 10,621 through 10,635 (of 19,560 total)
A heap is any table that does not have a clustered index. A table without a clustered index can become very fragmented very quickly even if it is just...
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
April 5, 2011 at 7:05 am
Brian Kukowski (4/3/2011)
You might want to check out the following free tool from SQL Sentryhttp://www.sqlsentry.com/plan-explorer/sql-server-query-view.asp
Brian
Certainly a great recommendation.
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
April 4, 2011 at 10:33 pm
Jeff Moden (4/4/2011)
shannonjk (4/4/2011)
The problem is that there are 4 files my ETL gathers from an...
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
April 4, 2011 at 10:32 pm
The owner of the job does matter. If an owner is set to something other than the default, then that person must have appropriate rights in SQL Server and...
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
April 4, 2011 at 10:27 pm
Great question. I actually use a question similar to this during interviews of candidates.
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
April 4, 2011 at 10:22 pm
Nice article and useful tool.
Thanks
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
April 4, 2011 at 10:19 pm
I read the line leading into the commentary about Zune and it gave me pause. Steve alluded to SSC going to a subscription model where access to certain areas...
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
April 4, 2011 at 10:10 pm
dma-669038 (4/4/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
April 4, 2011 at 8:00 pm
You're welcome and good luck.
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
April 4, 2011 at 7:59 pm
annasql (4/4/2011)
"Jason explained that those groups contain the necessary SID(s) to map back to Active Directory, which I'm now guessing is a way to abstract...
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
April 4, 2011 at 7:57 pm
annasql (4/4/2011)
Thanks, but the problem is I cannot see a group in our windows local group called, NT Service\SQLSEVERAGENT.You can try it too, it's not there.
Thanks
That is interesting - I...
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
April 4, 2011 at 7:53 pm
annasql (4/4/2011)
I cannot see our service account in it.
The account is not in the...
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
April 4, 2011 at 5:16 pm
Jack Corbett (4/4/2011)
Roy Ernest (3/31/2011)
Out of Curiosity, isnt 90K US or 80K Euro the normal salary for a Sr. DBA?
Definitely depends on region AND size of the company. I'm...
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
April 4, 2011 at 5:04 pm
Correct, the option to install the tools has to be selected.
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
April 4, 2011 at 5:02 pm
here is a query for you to see server roles.
select sp.name as UserAccount ,suser_name(rm.role_principal_id) as RoleName
from sys.server_role_members RM
Inner Join sys.server_principals SP
On RM.member_principal_id = SP.principal_id
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
April 4, 2011 at 5:00 pm
Viewing 15 posts - 10,621 through 10,635 (of 19,560 total)