Viewing 15 posts - 4,681 through 4,695 (of 49,552 total)
It can't be restored, but it can be opened in a hex editor and read raw. Won't be easy, but string data won't be that hard to get out. Numbers...
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 24, 2015 at 10:29 am
Luis Cazares (9/24/2015)
I'd usually go for something like this:
Delete T
FROM Event_Temp_Lead_Screen T
WHERE NOT EXISTS( SELECT 1 FROM member M...
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 24, 2015 at 10:27 am
It's not an object that's damaged, it's an allocation page, meaning SQL can't tell what should be in a 4GB chunk of the data file.
Restore from a clean backup, this...
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 24, 2015 at 7:09 am
Kristen-173977 (9/23/2015)
GilaMonster (9/23/2015)
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 24, 2015 at 7:05 am
robinwilson (9/23/2015)
Heaps
I was told this by the software supplier:
I accept that clustered indexes do seem like a simple...
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 24, 2015 at 7:03 am
Kristen-173977 (9/23/2015)
A Scalar function on an expression in a SELECT is probably OK (probably no different to actually hard-coding the logic in the SELECT).
No it's not OK, and...
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 23, 2015 at 3:24 pm
Though profiler, XE and the various dm_exec DMVs will still contain and show the plain text of the executed statement.
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 23, 2015 at 1:39 pm
WayneS (9/23/2015)
However, it comes at a cost - the accuracy of the data being reported is very suspect. As in, if you need accuracy then it can't be trusted.
Interestingly, in...
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 23, 2015 at 1:33 pm
robinwilson (9/23/2015)
Would a clustered index or a primary key (which seems to always create a clustered index anyway) be the better option generally in terms of...
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 23, 2015 at 11:57 am
bkshn (9/22/2015)
I want to save real datatype!!!
Why?
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 23, 2015 at 7:15 am
Then once you're restarted in single user mode, use the DAC to connect. Connections made via the DAC don't fire login triggers.
Start SQL in single user mode to get a...
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 23, 2015 at 7:11 am
In that case, it's not the login trigger that's your problem, as a non-sysadmin account can't create a sysadmin login.
Restart SQL in single user mode and connect with a windows...
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 23, 2015 at 6:49 am
chudman (9/23/2015)
So scan density was basically physical fragmentation? Is this correct?
No.
SQL's not aware of physical fragmentation, of how the files are placed on the drives. Which is why I...
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 23, 2015 at 6:41 am
All the sysadmin logins? Or all the SQL authentication ones?
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 23, 2015 at 6:34 am
saum70 (9/23/2015)
Connecting via DAC requires to specify User Id and password.
No it doesn't. It requires a sysadmin login, SQL or Windows.
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 23, 2015 at 6:11 am
Viewing 15 posts - 4,681 through 4,695 (of 49,552 total)