The Microsoft SQL Server Team has recently posted about one of the really exciting enhancements to SQL Server 2019 – Big Data Clusters
The ultimate performance for your big data with SQL Server 2019 Big Data Clusters
Leave a Comment
You are browsing archives for
Tag: T-SQL
SQL Server Engineering Team – New Website for Important SQL Server Info + Updates
A new home for the SQL Server engineering team to communicate important information about SQL Server with the community. We have migrated several SQL Server related blogs to this new home in the SQL Server TechCommunity. Click here for the new SQL Server Engineering Team blog. There’s also a list of links to some of their […]
Get free technical eBooks on SQL Server 2017 from Microsoft
Build your Microsoft SQL Server expertise with technical deep dives for your database journey. Free PDF eBooks from Microsoft SQL Server eBook series Get the technical resources and documentation you need to explore SQL Server 2017 – a comprehensive, mission-critical database for demanding workloads. With this series of technical eBooks on SQL Server, you’ll learn […]
SQL Server on Linux: A guide to re-platforming and modernizing your data workloads
SQL Server Table Function Performance
Rob Farley has a great post on when is a SQL function not a function? Read the two below functions – they return the same thing, but one is more effecient than the other. If you can’t see why, head over to Rob’s post that shows the execution plans for a great explaination. CREATE FUNCTION dbo.FetchSales_inline(@salespersonid […]
ANSWER: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’
I came across an interesting problem last night – a stored procedure that had been created years ago was suddenly coming up with this error message: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or […]
Unsigned Integer Datatype in SQL Server 2005
There’s been some interesting questions by users on the SQL Server Engine Tips blog. While almost all of them seem to be off topic, there are some interesting ideas. One of the fun ones was from Dave asking “Can we have some unsigned int data types?”. As a basic background for those of us who […]
Capturing STDERR output from SQLCMD.exe
Today while working with a .bat file full of SQLCMDs with really verbose output, I wanted just to capture error messages that were being sent to STDERR without changing the .sql files. I know how to capture/redirect handles in a variety of programming languages, but I haven’t tried to do this in a windows command […]
Visual Studio Team Edition for Database Professionals CTP6 Released
Today marks the release of CTP6 of Visual Studio Team Edition for Database Professionals. I’m pretty excited to see the development of this Visual Studio product. Finally database developers will be able to work like other programmers. Extreme Programming methods will be useful. Through Visual Studio projects and source control more developers will be able […]
Itzik Ben-Gan appearing at Sydney SQL Server Users Group – Tue 10th Oct 2006
Itzik Ben-Gan the T-SQL set based solution guru from Solid Quality Learning will be appearing at the Sydney SQL Server Users group on Tuesday 10th Oct 2006. Itzik will be discussing Internals and Externals of Table Scans and the access methods SQL Server uses to perform these and other scans. The Sydney SQL Server Users […]