Viewing 15 posts - 3,226 through 3,240 (of 49,552 total)
This should do the job
http://www.sqlservercentral.com/articles/books/89519/
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 18, 2016 at 9:07 am
Is the SQL Server service on your machine running? Not Express, from the server name you listed it doesn't look like you're connecting to the express version of SQL (usually...
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 18, 2016 at 5:29 am
sayedkhalid99 (4/17/2016)
What other changes i need to bring to improve performance ,
The usual process of identify the slow queries, tune them (indexes and/or queries). Repeat until performance is acceptable.
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 18, 2016 at 2:53 am
GonnaCatchIT (4/15/2016)
If the Query plans are being generated differently on 2 environments. then isn't it related to the DB settings, h/w etc.. ?
Maybe, maybe not. Could be stats, data volumes...
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 18, 2016 at 2:52 am
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 18, 2016 at 2:50 am
Mad-Dog (4/17/2016)
why is that?it hurts query performance badly..
Because the Profiler GUI uses latches to sync the display, meaning the server runs far slower, and sometimes even crashes.
Don't ever use 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 18, 2016 at 2:49 am
Phil Parkin (4/15/2016)
Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!
I'm going to have to steal "Don't have a clue how to optimize this due...
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 15, 2016 at 2:51 pm
Brandie Tarvin (4/15/2016)
This question was removed from Server Fault for reasons of moderation. Please refer to the help center for possible explanations why a question...
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 15, 2016 at 7:54 am
Ed Wagner (4/15/2016)
For errors in the PFS, GAM, SGAM or IAM pages, are there any viable options for recovery without going to a backup?
Depends on how widespread. If just 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
April 15, 2016 at 7:41 am
Brandie Tarvin (4/15/2016)
GilaMonster (4/15/2016)
Brandie Tarvin (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspxI don't have backup.
How does one get incorrect page IDs in the headers?
Seriously. I'm trying to figure out how that one is possible.
Pages...
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 15, 2016 at 7:36 am
Kazmerelda (4/15/2016)
Hugo, can I ask what was sloppy about my code?
Not Hugo, but...
Column names with spaces in. Ordering by an ordinal position instead of the column name. Formatting (there...
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 15, 2016 at 7:04 am
jeff.mason (4/15/2016)
I can't say I have ever seen a SAN LUN fail to that degree.
It happens. Not common, but it happens. I've seen a case where a SAN...
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 15, 2016 at 6:49 am
Grumpy DBA (4/15/2016)
GilaMonster (4/15/2016)
Brandie Tarvin (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspxI don't have backup.
How does one get incorrect page IDs in the headers?
Seriously. I'm trying to figure out how that one is possible.
Pages...
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 15, 2016 at 6:42 am
Brandie Tarvin (4/15/2016)
BLOB_EATER (4/15/2016)
GilaMonster (4/15/2016)
*sigh* http://www.sqlservercentral.com/Forums/Topic1778081-433-1.aspxI don't have backup.
I read "by creating empty DB and taking it offline and deleting and replacing dummy .mdf and .ldf files with my DB".......
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 15, 2016 at 6:36 am
Probably not. From the errors a portion of the data file has been overwritten by zeros. Whatever was originally there is lost for good.
You have several problems (excluding 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 15, 2016 at 6:31 am
Viewing 15 posts - 3,226 through 3,240 (of 49,552 total)