Esoteric

The inside scoop on SQL / debugging you won't find anywhere else!
Posts
  • Esoteric

    Concurrency of Full, Differential and Log backups on the same database

    • 1 Comments
    Overview Many a time, we are asked by customers about the effect of overlapping backup schedules: for example, whether they can backup the transaction log at the same time that a long-running complete backup of the database is taking place. Books Online...
  • Esoteric

    SQL Server setup log locations and more

    • 1 Comments
    In order to efficiently troubleshoot problems involving failed setup, we need to use the setup logs. Once you know where the log files are located, you can start troubleshooting. What to look for in the log files is a separate topic in itself, but at...
  • Esoteric

    Windows, SQL Server and Multi-Core / Hyper-Threading

    • 4 Comments
    Very often we get asked a question about 'how many processors does my SQL Server 200x Edition really support'. This post hopes to summarize the considerations and actual limits. SQL Licensing is per socket First, let's take a look at the Books Online...
  • Esoteric

    T-SQL Anti-pattern of the day: 'all-in-one' queries

    • 8 Comments
    Scenario A common requirement for enquiry queries on an OLTP database is to have search criteria which are very specific ('get me details for for OrderID = NNNN') and also the occasional reports which ask for all the orders ('get me all the orders...
  • Esoteric

    T-SQL Anti-pattern of the day: comparing DATETIME field with date-only literal

    • 1 Comments
    Scenario It is a pretty common situation to have transaction date-time stored in a DATETIME field. The problems start with the fact most applications used GETDATE() or some such equivalent at the client side to record the order date-time stamp. So a typical...
  • Esoteric

    T-SQL Anti-pattern of the day: UPPER() and LOWER()

    • 2 Comments
    This one is even more common and therefore has a high impact: the usage of the above functions in WHERE clause predicates. I've examined each in some detail below. Here's a typical example I see, based off the AdventureWorks database. Scenario To illustrate...
  • Esoteric

    T-SQL Anti-pattern of the day: Prefix codes stored in (n)varchar fields

    • 0 Comments
    In the course of my work as a SQL Server Premier Field Engineer, we tend to see a lot of patterns in code. Some of these patterns do not lend themselves to optimal performance. This post is the first in a series of such 'how not to code' tips which would...
  • Esoteric

    SQL Worker Thread Stack Sizes

    • 1 Comments
    Recently during some internal discussions we had a lot of talk around the stack sizes for various SQL builds. Here is the summary of that talk: SQL Server Build OS Build Stack Size SQL Server x86 (32-bit) x86 (32-bit) 512 KB SQL Server x86 (32-bit) x64...
  • Esoteric

    Using PowerShell to cleanup older versions of files

    • 0 Comments
    I only recently started using PowerShell and was amazed with the flexibility and ease of use. Here's a sample script I put together after a few hours of playing around. I have also described the scenario around the requirement for this script. Task at...
  • Esoteric

    'Interesting Events' from ReadTrace

    • 0 Comments
    I'm sure many of you are aware of the wonderful RML Tools (description here and x86 download here ) and specifically the ReadTrace tool. Maybe you are also aware of SQLNexus which relies on ReadTrace for the trace analysis. At some point in time when...
  • Esoteric

    NOT NULL and SWITCH TO PARTITION

    • 1 Comments
    Today I was to execute a ALTER TABLE... SWITCH TO PARTITION... operation to SWITCH an unpartitioned table into a partitioned table. I had taken care of the normal documented prerequisites: Same schema for both tables CHECK CONSTRAINT on the unpartitioned...
  • Esoteric

    Exploring LINQ

    • 0 Comments
    I just got some time to look into newer things, and one of the most intriguing is LINQ (Language INtegrated Query). I'm just sharing some useful links I came across over a night of browsing for information: http://msdn2.microsoft.com/hi-in/library...
  • Esoteric

    Connectivity related questions

    • 0 Comments
    Some time back there were some connectivity related questions thrown at me: Q1. We know about the Dedicated Admin Connection (DAC) and how it is useful for troubleshooting service hang issues. We also know that DAC should only be used when necessary...
  • Esoteric

    The role of STOPAT in RESTORE DATABASE

    • 1 Comments
    Previously in SQL Server 2000, the STOPAT clause was provided for RESTORE LOG wherein you can "halt" the recovery process at a particular point in time. This feature is very useful for recovering from accidental user errors and such. Now in SQL Server...
  • Esoteric

    Enforcing password policy for all SQL Authentication Logins

    • 0 Comments
    One of my customers recently asked me how we can enforce the CHECK_POLICY option for all logins created on the SQL 2005 instance. Since by default this is enforced on a per-login basis, we cannot by default have it at a server level. But by using DDL...
  • Esoteric

    Symbols and symbol files

    • 5 Comments
    Some of us are unaware of the relevance of proper symbols files. The symbol file is a deliverable just like the binary. Though it is not required for running the application, it is very important to debug issues which arise in production. What are...
  • Esoteric

    Resources from TechEd sessions

    • 0 Comments
    Several attendees have asked for the resources section from our presentations at TechEd India. Enjoy! Blogs SQLCAT: http://blogs.msdn.com/sqlcat WINCAT: http://blogs.msdn.com/wincat Slava Oks’ blog: http://blogs.msdn.com/slavao Product Feedback...
  • Esoteric

    Wait types in SQL Server

    • 0 Comments
    Troubleshooting performance issues in SQL Server involves studying the wait types and wait times associated with the queries executing. However, the relevance of each of the various wait types in the output can be a mystery. For SQL Server 2000, the...
  • Esoteric

    Tracer tokens in Transactional Replication

    • 0 Comments
    A new feature of SQL Server 2005 Transactional Replication is the ability to use "Tracer Tokens" to measure true latency between publisher-distributor and also distributor-subscriber. More details at Measuring Latency and Validating Connections for Transactional...
  • Esoteric

    Database Mirroring Technical Paper

    • 3 Comments
    One of the most exciting new features in SQL Server 2005 is DB Mirroring. Now that Service Pack 1 is released, we officially support this feature. A really useful resource to understand the options available in using this feature and their pros...
  • Esoteric

    Database Snapshots

    • 0 Comments
    DB Snapshots are a very useful new feature in SQL Server 2005 Enterprise Edition. They provide us the ability to preserve a consistent picture of the database as it was at a point in time. Both metadata and data are captured in the snapshot. The...
Page 5 of 5 (121 items) 12345