Viewing 15 posts - 26,716 through 26,730 (of 49,552 total)
Ok, let me be clearer.
Why are you disabling and re-enabling triggers?
Do you realise that if some other update runs, from another session, during yours, the triggers wil be disabled 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
April 14, 2011 at 6:24 am
Grant Fritchey (4/14/2011)
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 14, 2011 at 6:11 am
You cannot consolidate files during a restore. A restore will recreate the database exactly how it was at the time of the backup, file size and file numbers included. Once...
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 14, 2011 at 6:02 am
That's a schema stability lock. All queries in all isolations take schema stability locks so that the table cannot change in structure while they are working on it.
What's causing 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 14, 2011 at 5:59 am
Since the cast gets you waht you want, apply the cast to the results of the sum.
select cast (sum(annual_salary) as decimal (8,0)) as Total
from dbo.Employees
where Department_No='80'
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 14, 2011 at 5:47 am
Brandie Tarvin (4/14/2011)
I haven't read the article in question, but as a proofreader,...
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 14, 2011 at 4:53 am
However, unless you had an audit running when the delete happened that won't help this time. It'll help for future occurrences.
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 14, 2011 at 4:41 am
ben.reese (4/14/2011)
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 14, 2011 at 3:23 am
srikant maurya (4/14/2011)
SELECT TOP 5
columnname,
...
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 14, 2011 at 2:00 am
None.
There's no OPTION(Run SQL Fast)[/url] hint. If the query is not performing, you need to tune it, not try random hints that you don't understand.
Using hints is like saying...
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 14, 2011 at 1:57 am
fname lname-1111520 (4/14/2011)
"then" and "there's"... I didn't find it incoherent. I claimed "it can't be coherent". If I were reviewing resumes, you go in the Engrish pile.
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
April 14, 2011 at 1:54 am
Craig Farrell (4/13/2011)
WayneS (4/13/2011)
CirquedeSQLeil (4/13/2011)
Jack Corbett (4/13/2011)
Craig Farrell (4/13/2011)
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 13, 2011 at 11:18 pm
maheshsoft1987 75072 (4/13/2011)
actually i have one general question..............Is it possible to restore a full backup on same database without overwrite?
Best if you post in a new thread with an appropriate...
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 13, 2011 at 3:11 pm
maheshsoft1987 75072 (4/13/2011)
But you should share this experience, so beginners can understand and prepare and trace on difficulties..
So you're asking me to break the rules, get all of my certifications...
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 13, 2011 at 3:10 pm
Everyone who writes the exam accepts an NDA (non-disclosure agreement) that prohibits them from discussing anything about the exam's contents.
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 13, 2011 at 2:17 pm
Viewing 15 posts - 26,716 through 26,730 (of 49,552 total)