Viewing 15 posts - 19,396 through 19,410 (of 19,560 total)
This has me interested. I am checking some things and testing to see if they will work.
From MSDN:
Caution:
A user with ALTER permission on a schema can use...
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
September 2, 2009 at 3:09 pm
Can't wait for the audio to be made available for download.
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
September 2, 2009 at 12:36 pm
You know the saying...
It's not really paranoia if they are out to get 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
September 2, 2009 at 10:43 am
Try this article.
Grant Create View to ViewUser;
There is additional info explained in the article about using the "as" option.
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
September 1, 2009 at 3:37 pm
GilaMonster (9/1/2009)
timothyawiseman (9/1/2009)
Similarly, even if SQL is on a server by itself its apparent performance can be slowed down if there is heavy network traffic at the moment.
I've seen 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
September 1, 2009 at 3:26 pm
jasonmorris (9/1/2009)
Is write caching a good thing on san disks?
Answer is, it depends.
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
September 1, 2009 at 3:21 pm
This may not be precisely what you want or need.
We have in the past added a lun as a mount point in an already existing lun. This makes it...
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
September 1, 2009 at 3:17 pm
Here's an article that might be of use. Once the port has been statically set - this issue should go away.
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
September 1, 2009 at 3:13 pm
please provide some more information so we can better understand the situation. Your last couple of posts indicate a job being run vs. in SSMS. Will you explain...
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
September 1, 2009 at 2:57 pm
Sourav,
You will need to let the rollback complete - it is going to happen one way or another. If there is a massive impact on the server due 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
September 1, 2009 at 2:49 pm
Thanks for posting back after you found the solution to your 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
September 1, 2009 at 2:46 pm
How long has it been since the issue last occurred (6 months)?
How long has it been since you installed SP3?
Do you remember how to re-enable the trace flags?
If you are...
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
September 1, 2009 at 2:43 pm
Alternatively, script the tables and indexes from both databases and then use something like beyondcompare to see if / where there are differences
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
September 1, 2009 at 2:39 pm
RedGate has a tool called SQLCompare that can do this for 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
September 1, 2009 at 2:37 pm
Thx - this will prove useful in the new environment i just inherited.
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
September 1, 2009 at 11:36 am
Viewing 15 posts - 19,396 through 19,410 (of 19,560 total)