Viewing 15 posts - 35,401 through 35,415 (of 49,552 total)
CheckDB does not repair unless a repair level is specified.
Please note, repair should never be the first thing considered for a corruption problem. In many cases it's the last...
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
December 9, 2009 at 6:01 am
Sorry, don't understand. Table structure, sample data and some details on what should be returned when and how would be useful.
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
December 9, 2009 at 5:59 am
Firstly, what's been done with those 2.1 million rows?
Try creating this index
BD1_A_SALFLDG ([ACCNT_CODE], [AUTHORISTN_IN_PROGRESS], [PERIOD],[CONV_CODE])
Post new exec plan if it makes any difference.
The reason those clustered index seeks are taking...
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
December 9, 2009 at 1:50 am
Steve Jones - Editor (12/8/2009)
- for stored procs/UDFs, drop and recreate on filegroup1.
Stored procs, views and functions cannot have a filegroup specified. They're always stored inside the system tables which...
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
December 9, 2009 at 1:43 am
What do you mean by 'returning differently'? Bear in mind that all 5 rows have exactly the same value for the Date column, so in this case, any order 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
December 9, 2009 at 1:40 am
v_charalambous (12/9/2009)
Thanks for your help. How do i mark the post as closed?
You don't. Don't worry about it.
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
December 9, 2009 at 1:38 am
Bru Medishetty (12/8/2009)
Session 1 -- Using Books Online
Session 2 -- Using Management Studio
Session 3 -- Parsing...
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
December 8, 2009 at 3:15 pm
The Dixie Flatline (12/8/2009)
Wow. This one must take some prize.
:-P:-P:-P
Forgive my cruel chuckle at your expense.
Especially after the newest development. Don't even think it's SQL Server. More likely Oracle, at...
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
December 8, 2009 at 3:05 pm
One thing, looking at the other thread you posted, is this a SQL Server 2000 database server? Or are you working with a different database engine, like Oracle?
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
December 8, 2009 at 3:02 pm
That's not a SQL Server procedure. That's Oracle.
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
December 8, 2009 at 3:01 pm
Wow. This one must take some prize.
http://www.sqlservercentral.com/Forums/Topic830002-8-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
December 8, 2009 at 2:56 pm
You do know that query analyser has the capability to do a syntax check for you, without running the code?
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '('.
Msg...
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
December 8, 2009 at 2:52 pm
RBarryYoung (12/8/2009)
Not the usual, but I could use help with this one: http://www.sqlservercentral.com/Forums/Topic830994-1199-1.aspx
Sorry, not unless you're paying airfare. (and probably not even then)
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
December 8, 2009 at 2:18 pm
What's the solution to what?
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
December 8, 2009 at 2:07 pm
Lynn Pettis (12/8/2009)
Jack Corbett (12/8/2009)
Great now I can't get that voice out of my head!hmm, Yoda you hear when mine you read, right?
I certainly do.
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
December 8, 2009 at 1:25 pm
Viewing 15 posts - 35,401 through 35,415 (of 49,552 total)