Viewing 15 posts - 27,256 through 27,270 (of 49,552 total)
Other than games? 😀
Writing. I've probably done more blogging from the iPad than from my computer since I bought it. It's far more convenient if I want to go and...
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 20, 2011 at 10:55 am
What does your testing show? Have you looked at the execution plans, duration and IO statistics of each?
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 20, 2011 at 10:39 am
Attaf_T (3/20/2011)
Thanks for your advice.But I ask why sql Server do that?
Why sql dont save (0.123123 as 0.123123000000000000000)
Float is by definition an imprecise data type. It has to do 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
March 20, 2011 at 10:38 am
henryvuong1000 (3/19/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
March 20, 2011 at 3:36 am
Could well have.
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 20, 2011 at 3:34 am
Marios Philippopoulos (3/19/2011)
Can you elaborate on the latter two? "table parameters or cached temp table shells".
For table-type parameters see Books Online.
Since 2005 SQL can cache temp tables that are frequently...
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 20, 2011 at 3:34 am
Craig Farrell (3/19/2011)
It's griping because of the single-user mode.ALTER DATABASE [BTData] SET MULTI_USER WITH NO_WAIT
Disconnect object explorer before you try running that. The database currently only allows one connection (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 19, 2011 at 4:55 pm
CHECKDB found 0 allocation errors and 0 consistency errors in database 'BTData'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Yup, that's a success.
Right. Now since that'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
March 19, 2011 at 4:32 pm
There's no way in SQL to link a temp table back to its session.
The tables with hex names are table variables, table parameters or cached temp table shells.
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 19, 2011 at 4:29 pm
MothInTheMachine (3/19/2011)
Is there a way to extend the timeout period for the lock during this process?
Yes, write the query, don't use the GUI. Query windows have timeout of 0 (forever)
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 19, 2011 at 4:20 pm
Good. Fortunately not fatal. Consider yourself lucky.
ALTER DATABASE BTData SET EMERGENCY
ALTER DATABASE BTData SET SINGLE_USER
DBCC CHECKDB('BTData', REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE BTData SET ONLINE
Run them one by one if any give an error...
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 19, 2011 at 3:42 pm
Exactly as you have, just replacing the ` (at the end of the database name) with '
However if the database is suspect, that will fail. You cannot checkDB a suspect...
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 19, 2011 at 3:29 pm
henryvuong1000 (3/19/2011)
So when I overwrote the original file with the "Backup" (or that's what I thought) file, I have replaced the original file with a useless file?
Quite possible.
If that...
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 19, 2011 at 3:00 pm
henryvuong1000 (3/19/2011)
Note that I did not use any tsql command why performing the above operations. I only used GUI.
What do you mean you used the GUI? There's no mechanism through...
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 19, 2011 at 2:45 pm
ALZDBA (3/19/2011)
Whats the length of "varchar" ? by default 15 !
1 in a declare, 30 in a cast.
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 19, 2011 at 2:42 pm
Viewing 15 posts - 27,256 through 27,270 (of 49,552 total)