Viewing 15 posts - 2,116 through 2,130 (of 49,552 total)
You missed a zero
with a thousand separator added your filter was: duration>200 000, so filtering for duration greater than 0.2 seconds
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
November 12, 2016 at 5:37 am
Run Management Studio as the admin user, then connect to SQL as normal.
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
November 11, 2016 at 7:39 am
ankit87 (11/10/2016)
Recently I have attended a job interview for sql server dba and was asked critical issue you have faced as a dba can anyone help..
They're asking for...
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
November 11, 2016 at 1:31 am
With a heap, if you delete all the rows, the only time the pages are deallocated is if the delete took a table lock (by force or by choice iirc)
Safest...
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
November 10, 2016 at 1:13 pm
Ed Wagner (11/10/2016)
TOS = Very GoodTNG = Great
DS9 = No
Voyager = Only after 7 of 9 / the Borg came into the picture
Enterprise = No
My only difference there would be
DS9...
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
November 10, 2016 at 1:10 pm
whitesql (11/10/2016)
for example I want to delete first 500 records so that it will not eat a lot of resources if I have millions of records
TRUNCATE, which is what was...
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
November 10, 2016 at 6:32 am
Ed Wagner (11/10/2016)
Eirikur Eiriksson (11/10/2016)
GilaMonster (11/10/2016)
sql 2005 to oracle11g database upgrade please send the step by step process
Um, ok...
Wooosh and no clue
~~~~\o/~~~/\~~~~
😎
Heh - Did you direct them to...
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
November 10, 2016 at 5:25 am
I'd take this opportunity to switch from maintenance plans for index rebuilds (which are inefficient and error-prone) to Ola's index maintenance solution (http://ola.hallengren.com/), as well as fixing the other identified...
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
November 10, 2016 at 5:14 am
sql 2005 to oracle11g database upgrade please send the step by step process
Um, ok...
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
November 10, 2016 at 5:07 am
To start with, fix that broken caps lock.
I'd start by speaking with SAP, they'll have more insight on what's required to port one of their applications to a different 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
November 10, 2016 at 5:06 am
Eirikur Eiriksson (11/10/2016)
21.naved (11/10/2016)
we do not run dbcc checkdb but there have been some reindex jobs successful whereas some failed.can I run it online during working hours?
Yes you can.
While...
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
November 10, 2016 at 4:42 am
That's not an upgrade, that's a complete re-write on the new platform.
All tables will need to be re-done with Oracle's data types, all stored procedures, functions and views will need...
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
November 10, 2016 at 4:38 am
21.naved (11/10/2016)
we do not run dbcc checkdb
Seriously? Why on earth not? Do you want to find out about corruption only after it's too late to fix?
DBCC CheckDB ('<database name>') WITH...
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
November 10, 2016 at 4:32 am
You might have corruption in that DB. When did you last run a successful checkDB?
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
November 10, 2016 at 2:06 am
Since the consequence of making too low a log reservation can be very severe (DB goes SUSPECT if a rollback can't complete), the algorithm that estimates how much space will...
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
November 10, 2016 at 2:04 am
Viewing 15 posts - 2,116 through 2,130 (of 49,552 total)