Viewing 15 posts - 26,656 through 26,670 (of 49,552 total)
Data files need to be on a local drive, not a network drive. The network file protocol does not support the IO requirements that SQL has. In addition, network glitches...
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, 2011 at 4:00 am
shishir999_ril (4/18/2011)
Thanks Dave, I tried but didnot work. Even I tried using Row_Number clause but no luck.
What did you try?
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, 2011 at 2:46 am
The Case looks ok, but NVL is not a SQL function. What does it 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
April 17, 2011 at 11:42 pm
armurugesh (4/17/2011)
the sql server executes...
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 17, 2011 at 11:32 pm
Is this for display purposes?
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 17, 2011 at 11:24 pm
That's what an index rebuild/defrag does.
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 17, 2011 at 4:49 pm
Well then, first you need to create the stored procedures listed in that maintenance article.
Honestly though, defragmenting may not help that much. Depends what's wrong. 90% of cases 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
April 17, 2011 at 2:54 pm
Whoever 'he' is, he's right. That command is completely invalid syntax.
As I said, read up on tail-log backups in SQL books online. There's an entire entry on how and when...
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 17, 2011 at 2:40 pm
If you are in full recovery model and have log backups then, depending on the type of crash, you may be able to take a tail-log backup and recover 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 17, 2011 at 2:30 pm
That's not a standard procedure, not something that is automatically part of a database (and I assume you mean the proc doesn't exist rather than dbo not existing).
Ok, let's...
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 17, 2011 at 2:23 pm
I'd prefer a good backup strategy of the entire database, rather than exports of a single table.
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 17, 2011 at 1:03 pm
Parsing doesn't check that the object is there. It just checks that the SQL syntax is fine.
EXEC dbo.ProcThatDoesNotExist
Parse that and you get "Command(s) completed successfully."
So short answer, the procedure does...
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 17, 2011 at 12:54 pm
You could call that table-level backup, but it's really just making a copy of the table within the same database. SQL doesn't have the ability to backup tables (using 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 17, 2011 at 12:42 pm
Please note: 3 year old thread.
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 17, 2011 at 12:38 pm
How are you calling this from VB?
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 17, 2011 at 7:09 am
Viewing 15 posts - 26,656 through 26,670 (of 49,552 total)