SQL Saturday is coming to Albuquerque on January 25, 2014. Join us for a free day of SQL Server training and networking. This SQL Saturday also features 2 paid-for preconference sessions presented by Denny Cherry and William E. Pearson III.
2014-01-06
1,658 reads
Red Gate are looking for participants in a short short survey on SQL Server database releases. At the end you will be given a chance to enter an e-mail address to win a $50 Amazon gift certificate.
2014-01-06 (first published: 2013-12-20)
3,629 reads
Receive Deadlock info from the SQL Error Log every time a deadlock occurs.
2014-01-03 (first published: 2010-12-13)
55,299 reads
SQL Server DBAs are often responsible for managing large number of database instances. This article talks about the concept of a Configuration Repository where DBAs can manage all the information related to their SQL Servers
2014-01-03
4,309 reads
As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.
2014-01-02 (first published: 2013-11-04)
17,207 reads
Microsoft is releasing SQL Server 2014 with a new set of In-Memory OLTP features to significantly improve the OLTP performance and reduce the processing time for servers with a large amount of memory and multi-core processors. Check out this tip to learn more.
2014-01-02
3,724 reads
Use CMS and Extended Properties to store information about multiple servers, including the stakeholders who should know about any maintenance you are planning.
2014-01-01 (first published: 2010-11-30)
9,228 reads
In this series of short articles, we lift the hood of the SQL Server Optimizer to examine a few of the many clever tricks used to optimize query performance. In Part I, we look at partial aggregate operators – an extremely clever way of downsizing certain large joins into much smaller (and faster) joins.
2014-01-01
3,857 reads
How to use Profiler to generate TSQL scripts that can be modified and automated to run as a server-side trace
2013-12-31 (first published: 2010-12-02)
13,582 reads
Big data is now a standard part of information technology architecture for most large organizations. As a database administrator, with the holiday season upon us, I have the following items and notions on my holiday wish list. Here's hoping that I am gifted one or more of these; each one gives me something that I want or need.
2013-12-31
4,492 reads
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Comments posted to this topic are about the item Why SQL Server Database Attach...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers