Viewing 15 posts - 3,226 through 3,240 (of 49,571 total)
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...
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.
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...
April 18, 2016 at 2:52 am
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...
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...
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...
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...
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...
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...
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...
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...
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".......
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...
April 15, 2016 at 6:31 am
Viewing 15 posts - 3,226 through 3,240 (of 49,571 total)