Viewing 15 posts - 40,681 through 40,695 (of 49,552 total)
Ratheesh.K.Nair (3/2/2009)
Can you please explain? I tried opening in notepad but i didnt find anything..
Notepad is not a hex editor.
Unless you are intimately familiar with the structure of database pages,...
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
March 2, 2009 at 5:53 am
cshekhar (3/2/2009)
Simply i need to remove this protection in some cases, for that scenario how can i ?
Disable the trigger.
A better approach than a DDL trigger would be to ensure...
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
March 2, 2009 at 5:12 am
pedro.ribeiro (3/2/2009)
In my case , i have the same problem (suspect database).
Please post your problem in a new thread in the appropriate forum (SQL 2000 is this...
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
March 2, 2009 at 5:09 am
Short of opening the mdf in a hex editor and finding the version code in the header page, no.
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
March 2, 2009 at 5:06 am
AShehzad (3/2/2009)
Now, I have to get columns of temp table from information_schema.columns
Why? The only tables that should be in tempDB are temp tables that your session has created. Hence...
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
March 2, 2009 at 5:01 am
cshekhar (3/2/2009)
But i can see the data which is after the reboot (StartTime), but i need the information of before recycle.
There should be 5 trace files. What about 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
March 2, 2009 at 5:00 am
A Little Help Please (3/2/2009)
Question, what do you mean by:Compat mode 80/90?
Look up Compatability level in Books Online
How would I:
update all statistics on 2005
Look up UPDATE STATISTICS in Books Online
run...
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
March 2, 2009 at 4:57 am
ALZDBA (3/2/2009)
GilaMonster (3/2/2009)
ALZDBA (3/2/2009)
If there is more than one concurrent "#temp" object, sqlserver will add stuff to the object name to make it unique.
SQL will always add a prefix, whether...
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
March 2, 2009 at 4:21 am
Either will work. Check compatibility before you move to 2005 (test restore, update advisor) as there's stuff that breaks even in compat mode 80.
Once on 2005 update all statistics, run...
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
March 2, 2009 at 3:47 am
Providing the default trace is running, and the table wasn't dropped too long ago, you can use that.
The default trace is 5 trace files of 20MB apiece that are put...
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
March 2, 2009 at 3:46 am
ALZDBA (3/2/2009)
If there is more than one concurrent "#temp" object, sqlserver will add stuff to the object name to make it unique.
SQL will always add a prefix, whether it's 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
March 2, 2009 at 3:41 am
Dean Jones (3/2/2009)
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
March 2, 2009 at 3:40 am
saravanantvr1984 (3/2/2009)
insert happening. If we using trigger we can do only for particular table,
but 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
March 2, 2009 at 12:53 am
Performance-wise it'll be about the same. However, as soon as you start using dynamic SQL you're creating a whole bunch of security issues and concerns, from greater permissions required (permissions...
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
March 1, 2009 at 10:26 am
Why do you want to pass an entire statement to a stored procedure?
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
March 1, 2009 at 5:37 am
Viewing 15 posts - 40,681 through 40,695 (of 49,552 total)