Viewing 15 posts - 17,746 through 17,760 (of 19,560 total)
Did the user get added to a server role as well? Did the user get added to DBO within the database?
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:04 am
Botelo
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 1:42 am
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 1:37 am
malleswarareddy_m (1/28/2010)
SET NOCOUNT ON
Does not reset the @@rowcount to 0.
@@rowcount is zero when we execute the system Defaults like as shown
set ansi_padding on
select @@rowcount
set nocount on
select...
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 1:09 am
stewartc-708166 (1/29/2010)
upon opening a new query window in ssms, try
set nocount ongo
select @@ROWCOUNT
select @@ROWCOUNT
then the result will be 0,1
otherwise it will be 1,1
This is correct, and thus makes the answer...
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 1:06 am
Please clarify "permissions on everything"
db_datareader gives a User permission to select from all tables within the database.
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 1:00 am
vstitte (1/29/2010)
1. Create a database role or as many roles you will need.
2. Assign appropriate permissions to this role
3. Assign the users to the database role 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
January 29, 2010 at 12:57 am
Paul White (1/29/2010)
GilaMonster (1/28/2010)
CirquedeSQLeil (1/28/2010)
We meet second Thursday of each month. Pacific Time zone.
Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm,...
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:49 am
Jeff Moden (1/28/2010)
CirquedeSQLeil (1/27/2010)
Jeff Moden (1/27/2010)
Alvin Ramard (1/27/2010)
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 am
Jeff Moden (1/28/2010)
CirquedeSQLeil (1/27/2010)
I am wrapping up an article and would like somebody else to review...
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:47 am
Paul White (1/29/2010)
Jeff Moden (1/28/2010)
Would someone explain to me the attraction to sites like Twitter and FaceBook and explain what they're actually good for so...
It's a bit like SQL Server...
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:45 am
Why not just use f5 or alt-x?
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 28, 2010 at 3:35 pm
In the comments section of
http://blogs.msdn.com/sqlrem/archive/2007/03/07/Performance-Dashboard-Reports-Now-Available.aspx
There is an explanation of how to resolve this. The cause is due to a stored proc and the date calculation.
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 28, 2010 at 3:31 pm
nom de plum
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 28, 2010 at 3:14 pm
This is a nice concept. It could be useful to help save money or help a DBA get an idea to create a health check of his/her own.
Thanks for...
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 28, 2010 at 2:36 pm
Viewing 15 posts - 17,746 through 17,760 (of 19,560 total)