Viewing 15 posts - 6,181 through 6,195 (of 49,552 total)
Poor performance is usually queries that can't use indexes or indexes which don't support the queries.
Remote access might be network latency, but if it is you'll need to talk...
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
April 14, 2015 at 2:41 am
sys.dm_db_persisted_sku_features
However I don't know if it's in SQL 2005
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
April 13, 2015 at 9:36 am
group by database_id, not by the function applied to database_id.
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
April 13, 2015 at 8:55 am
Sean Lange (4/13/2015)
GilaMonster (4/13/2015)
Not fixed. Large portions of the storage engine were rewritten between SQL 2000 and 2005.I would say that rewriting the storage engine is what "fixed" the problem.
😀
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
April 13, 2015 at 8:16 am
sql-lover (4/13/2015)
Ok Gail, now I'm curious... what populates those DMVs and what's the frequency they are populated? What's the mechanism that keep those in sync.
No idea. Probably same thing 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
April 13, 2015 at 8:15 am
Not fixed. Large portions of the storage engine were rewritten between SQL 2000 and 2005.
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
April 13, 2015 at 7:41 am
It's fairly safe. Good backups are something you should have anyway, not specific to an upgrade.
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
April 13, 2015 at 6:06 am
No backups? Really?
Run the following, post the full and complete output.
DBCC CheckDB('<database name>') WITH No_INFOMSGS, ALL_ERRORMSGS
You will lose data in the process of fixing this, so let the business owner...
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
April 13, 2015 at 6:04 am
jorge_gomes98 (4/13/2015)
So...the second or other people can read bad data...hum...ok...
No, that's not what I said.
Transactions and isolation levels prevent the second, third, etc people from reading data that the first...
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
April 13, 2015 at 5:38 am
Restore from a clean backup, one you took before the corruption occurred.
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
April 13, 2015 at 5:13 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Replies to http://www.sqlservercentral.com/Forums/Topic1676526-3411-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
April 13, 2015 at 5:11 am
Please go and do a lot of reading on the SQL injection vulnerability. And the fact that it's intranet changes nothing, it's vulnerable, you need to fix it.
There's lots...
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
April 13, 2015 at 4:59 am
In what context?
If you're talking backup/restore, there's been no major changes in the process of restoring in 2012
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
April 13, 2015 at 3:47 am
The very first thing you need to do is read up on SQL Injection, because your code is riddled with security vulnerabilities (unless you want your company's data exposed the...
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
April 13, 2015 at 3:21 am
If you need everything that starts with As, then you can't use an equality, the LIKE is probably the best.
Btw, don't look at the subtree cost. Costs are pretty much...
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
April 13, 2015 at 2:55 am
Viewing 15 posts - 6,181 through 6,195 (of 49,552 total)