Viewing 15 posts - 12,106 through 12,120 (of 19,560 total)
UMG Developer (9/27/2010)
Drikus Roux (9/26/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
September 27, 2010 at 4:26 pm
BTW - here's another good resource on the topic.
http://www.sql-server-performance.com/articles/dba/Analyzing_SQL_Server_Permissions_p1.aspx
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 27, 2010 at 4:08 pm
Derrick Smith (9/27/2010)
CirquedeSQLeil (9/27/2010)
Use master
GO
SELECT sp.permission_name, p.name
FROM sys.server_permissions sp
Inner Join sys.server_principals p
On p.principal_id = sp.grantee_principal_id
Where...
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 27, 2010 at 4:04 pm
Here is how you can now confirm whether or not the permissions granted have been applied:
Use master
GO
SELECT sp.permission_name, p.name
FROM sys.server_permissions sp
Inner Join sys.server_principals p
On p.principal_id = sp.grantee_principal_id
Where sp.permission_name = 'View...
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 27, 2010 at 4:01 pm
I also just ran back through this and tested for myself. The behavior exhibited definitely does not follow the article.
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 27, 2010 at 3:26 pm
Referring to http://www.mssqltips.com/tip.asp?tip=1593 - you would think that is the case. I haven't had success with it either.
Does your windows group already exist with permissions in each 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
September 27, 2010 at 3:21 pm
Michael Valentine Jones (9/27/2010)
Have you verified that the table is not a heap (has a clustered index)?
Very good point.
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 27, 2010 at 2:57 pm
miksh (9/27/2010)
CirquedeSQLeil (9/27/2010)
sp_updatestats did not work
dbcc updateusage did not work
dbcc checkdb shows no corruption?
The table is replicated
Index Rebuild did not work
Truncate table did not work
Are there any pending 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
September 27, 2010 at 2:53 pm
check dbcc opentran
I wonder if there is something that is preventing the table from releasing space
Also, is the db in full or simple?
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 27, 2010 at 2:51 pm
miksh (9/27/2010)
Btw, one of the columns of XML type if it helps you.
How many indexes?
Have all indexes been defragged / rebuilt?
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 27, 2010 at 2:42 pm
miksh (9/27/2010)
CirquedeSQLeil (9/27/2010)
Run a dbcc checktable and determine if there is any corruption.
It's when you don't like good news :crazy:
CHECKDB found 0 allocation errors and 0 consistency errors in 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
September 27, 2010 at 2:41 pm
To recap:
sp_updatestats did not work
dbcc updateusage did not work
dbcc checkdb shows no corruption?
The table is replicated
Index Rebuild did not work
Truncate table did not work
Are there any pending replication actions?
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 27, 2010 at 2:40 pm
Is this table replicated?
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 27, 2010 at 2:32 pm
Run a dbcc checktable and determine if there is any corruption.
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 27, 2010 at 2:32 pm
raistlinx (9/27/2010)
getoffmyfoot (9/27/2010)
Yea, the drop/create table is brutal...Maybe I am missing something here, could someone elaborate on why this is not good in this situation?
There used to be data...
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 27, 2010 at 2:28 pm
Viewing 15 posts - 12,106 through 12,120 (of 19,560 total)