The handling of dates in TSQL is complex - when SQL Server was Sybase, it was forced by the lack of prevailing standards in SQL to create its own ways of processing and formatting dates and times. Joe Celko looks forward to a future when it is possible to write standard SQL date-processing code with SQL Server.
Easily grant exec permission to all stored procedures to a database role in SQL 2005 or higher.
Much of the data collected by companies is being sold for profit. This data isn't treated well and while not much may change, perhaps we should be aware of how we handle data as professionals.
If you need to keep tabs on a number of servers and applications in a Windows domain then performance counters provide the bedrock of information. It is important to identify the counters you need and gather baseline data to allow you to create alerts when abnormal conditions occur.
, Quentin Clark, corporate vice president of the Data Platform Group, announced that SQL Server 2014, the foundation of Microsoft’s cloud-first data platform, is released to manufacturing and will be generally available on April 1.
Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.
When you've got only a single effective date on a record and you need to artificially create the effective end date based on a following row in T-SQL, the techniques discussed in this article will help you decide what is best.
The SQL Server Luxembourg user group will be meeting on March 26. This is a free event for all registered attendees, and will feature Richard Douglas and Tom Van Zele as speakers.
Paul Randal and Kimberly Tripp, together with their small team of experts at SQLSkills.com, dominate the high-end training and consultancy for SQL Server. We sent Richard Morris to find out a bit more about Paul, his views about SQL Server, his lifestyle, ambitions and plans.
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Good Afternoon, 1) I run a SSIS Package (.dtsx) in Visual Studio and it...
Good Afternoon, 1) I run a SSIS Package (.dtsx) in Visual Studio and it...
When the schema of an object is changed, SQL Server wipes out the previous...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers