Viewing 15 posts - 17,716 through 17,730 (of 19,560 total)
Is it alive? Anybody have a defibrillator?
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
January 29, 2010 at 3:19 pm
No.
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
January 29, 2010 at 2:59 pm
Do you have a backup of the master database?
A restore of the database is imminent.
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
January 29, 2010 at 2:55 pm
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
January 29, 2010 at 2:46 pm
crookj (1/29/2010)
Lynn Pettis (1/29/2010)
CirquedeSQLeil (1/29/2010)
Pro-bowl should be in the middle of the season.Good idea, midway in the season, and everyone has the same bye week.
In full agreement! Baseball and basketball...
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
January 29, 2010 at 12:48 pm
You could do this at the application layer. Using the same code for each connection, performance v. linked server should be negligible. The use of the BI tools,...
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
January 29, 2010 at 12:46 pm
Have you considered replication for this scenario?
Of course, since you are writing the application to perform the insert, you could also have it insert into the subsequent databases using 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
January 29, 2010 at 12:43 pm
What timing? I will repost that answer in the other thread.
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
January 29, 2010 at 12:41 pm
have you considered replication?
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
January 29, 2010 at 12:40 pm
Depending on the scenario, table variables could be better than temp tables. The same is true of temp tables being better than table variables. No single type is...
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
January 29, 2010 at 12:38 pm
delete
dbo.table1
from dbo.table1 as source
Inner Join dbo.table2 as dest
on dest.id = source.id
Is 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
January 29, 2010 at 12:31 pm
Looks like you have Heaps (which will show as indexes in the views). To defrag these, you will need to create a clustered index on the table.
However, it may...
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
January 29, 2010 at 12:26 pm
Do you have good backups?
Are you able to start in single-user mode?
Are you able to start the DAC?
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
January 29, 2010 at 12:22 pm
Bill Gates-870674 (1/27/2010)
Hello,1.Can DBA lead an Organization and/or IT department?
Yes. Depends on the DBA though. Not all people are management types. Many DBA's are hands on...
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
January 29, 2010 at 12:19 pm
It depends on where you are a Production DBA. Production DBA is not the same thing from company to company. The depends part, comes down to how well...
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
January 29, 2010 at 12:12 pm
Viewing 15 posts - 17,716 through 17,730 (of 19,560 total)