Viewing 15 posts - 44,596 through 44,610 (of 49,552 total)
You'll need to test carefully even if you do leave the DB in 80 compat mode. There are enough changes (to the optimiser especially) to potentially break things even running...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 7:06 am
Shaun McGuile (9/10/2008)
Erm Ed, just one thing,removing read permissions on sys tables so the web app can't see them kills this type of attack stone dead.
It kills this particular instance...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 7:06 am
That is MSDE, as shown by the last line 'Desktop Engine on Windows NT 5.1'
MSDE will slow down after 8 concurrent queries. It's an intentional throttling and there is no...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 7:04 am
Online indexing won't work, neither will any of the new 2005 features. You will get the benefit of the improved query optimiser and other internal changes.
Why can't you change to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:50 am
sys.sql_modules
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:34 am
Please post the full result. Change QA to run to text, not to grid.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:33 am
At my previous company, we gave the devs dbo access to the DBs that they were working on (on the dev server), however there was a DDL trigger in place...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:32 am
The PSS engineers have looked into this and posted the following on the subject:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:17 am
The ITP exams for SQL 2008 won't be out til around November. I don't know if the upgrade exams will be out the same time, or later. I'd guess, offhand,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:15 am
It looks like you're running MSDE (the free SQL 2000 database engine). MSDE has a built-in throttle that limits it to a certain number of concurrent queries and you're exceeding...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:06 am
Please don't cross post. It just wastes people's time and fragments replies.
Markus answered your question over here:
http://www.sqlservercentral.com/Forums/Topic566620-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 2:02 am
Itzik Ben-Gan did a demo last year at PASS. It's got nothing to do with bad data. All it requires is that a page split occurs during a scan that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2008 at 1:46 am
I'll third the switch to read-only . Not only does it remove the need to consider locking at all, it also prevents anyone from 'accidentally' changing data in the reporting...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2008 at 1:20 pm
I got those numbers from Kimberly Tripp, and she did demos at the time that confirmed the aprox percentage where the switch was.
It does vary, as it depends on where...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2008 at 1:18 pm
I would argue that if you're getting hacked again and again, your asp code is not good.
All data access should be via stored procedures. Ensure that the user has no...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 9, 2008 at 1:12 pm
Viewing 15 posts - 44,596 through 44,610 (of 49,552 total)