Viewing 15 posts - 16,816 through 16,830 (of 19,560 total)
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
March 5, 2010 at 10:14 am
Jack Corbett (3/5/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
March 5, 2010 at 9:20 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
March 5, 2010 at 9:07 am
What you describe is similar to what would happen if the public role had been locked down.
Here is an article that discusses security and locking down sql server.
http://duartes.org/gustavo/articles/Lock-Down-SQL-Server-2005.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
March 5, 2010 at 12:12 am
Some resources:
http://support.microsoft.com/kb/225545
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
March 5, 2010 at 12:02 am
It seems that the application and database are competing for resources - memory being a good contender.
What are your memory settings for sql server?
Also, I would tune your sql queries...
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
March 4, 2010 at 11:57 pm
Has anybody locked down the public role?
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
March 4, 2010 at 11:52 pm
Henrico Bekker (3/4/2010)
Also depends on the needs of...
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
March 4, 2010 at 11:48 pm
This will eliminate the "NOT IN"
with apples as (Select [name] from tablename where fruit = 'Apple')
Select distinct t.Name
From TableName T
Left Outer Join apples a
On t.name = a.name
Where a.name is null
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
March 4, 2010 at 11:46 pm
I can tell you that a bare minimum ability to understand at a basic level is necessary. Being able to look at .Net code and understand what it 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
March 4, 2010 at 11:41 pm
It depends on whether you need to or not.
Will it be beneficial - sure.
You can apply what you learn in .Net to CLR procedures and to SSIS packages. Both...
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
March 4, 2010 at 11:35 pm
A few things to look at
http://en.wikipedia.org/wiki/Nested_RAID_levels
http://en.wikipedia.org/wiki/Standard_RAID_levels
For databases, RAID 10 would be better than 5. Anything less than 5 is commonly not considered as redundancy.
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
March 4, 2010 at 11:32 pm
To add to the list
1. missing indexes
2. amount of data
3. disk configuration
4. log file fragmentation (VLF)
There are a lot of things to look for when trying...
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
March 4, 2010 at 11:29 pm
Compiled applications? I don't know of any in particular.
There are a bunch of applets and scripts available for download.
Check out Glenn Berry's DMV scripts
Simple-talk.com has some SMO things 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
March 4, 2010 at 11:10 pm
Henrico Bekker (3/4/2010)
Noted, my apologies, didnt read the question thoroughly.🙂
NP
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
March 4, 2010 at 11:06 pm
Viewing 15 posts - 16,816 through 16,830 (of 19,560 total)