Viewing 15 posts - 6,181 through 6,195 (of 49,571 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...
April 14, 2015 at 2:41 am
sys.dm_db_persisted_sku_features
However I don't know if it's in SQL 2005
April 13, 2015 at 9:36 am
group by database_id, not by the function applied to database_id.
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.
😀
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...
April 13, 2015 at 8:15 am
Not fixed. Large portions of the storage engine were rewritten between SQL 2000 and 2005.
April 13, 2015 at 7:41 am
It's fairly safe. Good backups are something you should have anyway, not specific to an upgrade.
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...
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...
April 13, 2015 at 5:38 am
Restore from a clean backup, one you took before the corruption occurred.
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
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...
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
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...
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...
April 13, 2015 at 2:55 am
Viewing 15 posts - 6,181 through 6,195 (of 49,571 total)