Viewing 15 posts - 11,296 through 11,310 (of 49,552 total)
So is it fixed?
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
October 15, 2013 at 12:39 pm
dan-572483 (10/15/2013)
That's why SQL errors when conversion would lose data, unless you've already told it what to do by using a ROUND() or other function.
There's a huge amount of places...
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
October 15, 2013 at 11:17 am
http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html
https://www.simple-talk.com/sql/t-sql-programming/look-up-tables-in-sql-/
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
October 15, 2013 at 10:59 am
Want a cool Sig (10/15/2013)
Does this mean that SQL can't do an implicit conversion to float/decimal and then to an integer?
It's perfectly capable of doing an implicit or explicit conversion...
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
October 15, 2013 at 10:32 am
rodjkidd (10/15/2013)
You up to speed yet, by your tweets sounds like a long set of flights.
Awake. Mostly. The pot of coffee that came with breakfast helped.
8 hours JHB-Dubai
14 hours...
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
October 15, 2013 at 10:15 am
A full log will not send a database suspect. If your database is suspect, something else is the cause.
What does the SQL error log say?
What's the exact value for status_desc...
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
October 15, 2013 at 10:11 am
Because an int doesn't have decimal places.
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
October 15, 2013 at 10:09 am
The One True Lookup Table design. Also known to people who have worked with them as 'Oh $%$$%$$ not that thing again'
It's a 'design' that looks so attractive to people...
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
October 15, 2013 at 9:58 am
It might. Depends on what exactly and why.
My general rule - if a column is needed in a nonclustered index to support a query and it's part of the clustered...
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
October 15, 2013 at 9:50 am
rodjkidd (10/15/2013)
Well I have a camera... But yes I will update the thread on Gail's antics during WITRodders...
Oh dear....
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
October 15, 2013 at 7:01 am
inserted and deleted are simply pseudo-tables materialised from the transaction log records. SQL doesn't look at the table they're based off (except for data types and column names), so they...
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
October 15, 2013 at 7:00 am
Are they all 'sa'? Are they all low session_id? If you query sys.dm_exec_sessions, what do they show for 'IsUserProcess'
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
October 14, 2013 at 6:17 pm
polkadot (10/13/2013)
I think restarting SQL Server should have reset the numbers for SPID 54.
It did. No connections or connection-related information survives a restart.
Clearly, there is some spid hanging 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
October 13, 2013 at 9:01 pm
polkadot (10/12/2013)
GilaMonster (10/11/2013)
How are you identifying that the session 54 (which is your current session that you're running the sp_who from) is locking resources and preventing updates?
I'm concluding that session...
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
October 13, 2013 at 2:41 am
And to determine the best join types and order, aggregation, sorts (if necessary), whether or not to use work tables, how much memory to request, etc, etc
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
October 12, 2013 at 3:28 pm
Viewing 15 posts - 11,296 through 11,310 (of 49,552 total)