Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule
Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...
2018-01-23
456 reads
Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.
Sometimes your source...
2018-01-23
456 reads
Last week we looked at how easy it is to import GeoJSON data into SQL Server's geography datatype.
Sometimes your source data won't be perfectly formatted for SQL Server's spatial...
2018-01-23
26 reads
Introducing: The SQLUndercover Inspector! Finally we have a V1 almost ready to hit our GitHub but what exactly is it?
Just another...
2018-01-22
506 reads
The other day I ran into an odd problem trying to answer the following question on DBA.StackExchange:
How to filter out...
2018-02-01 (first published: 2018-01-22)
1,765 reads
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
146 reads
SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with...
2018-01-22
369 reads
Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...
2018-01-31 (first published: 2018-01-22)
2,425 reads
Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.
How it Works
In the same way...
2018-01-31 (first published: 2018-01-22)
2,269 reads
Learned new function for count while going through the channel 9 video for salva. where for a very big table...
2018-01-22
619 reads
The next edition of the SQL in the City broadcast is coming Feb 28, and I’m planning travel now to...
2018-01-30 (first published: 2018-01-22)
1,318 reads
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
This is my late response to T-SQL Tuesday #204. I almost always forget about...
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers