Viewing 15 posts - 11,296 through 11,310 (of 49,563 total)
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...
October 15, 2013 at 11:17 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...
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...
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...
October 15, 2013 at 10:11 am
Because an int doesn't have decimal places.
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...
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...
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....
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...
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'
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...
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...
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
October 12, 2013 at 3:28 pm
Viewing 15 posts - 11,296 through 11,310 (of 49,563 total)