T-SQL can be a complex language to work within and code solutions with. Author Stephen Lasham brings us a twist on his last solution of extracting a string from within another string. Read about his method of working with strings in T-SQL.
2004-09-13
7,862 reads
NULL values in columns can indicate a few things, the value isn't known, it's not yet been filled in, or perhaps, as Leo Peysakhovich argues, the column isn't being used? How many SQL Server tables do you have with extra tables and columns that are not being used? Or maybe never have been? This article looks at a statistical analysis of columns using NULLs to determine if you might be able to remove certain columns.
2004-08-25
9,327 reads
SQL Server can grow to encompass hundreds of databases on a single server, each having hundreds or thousands of objects within it. A truly scalable RDBMS. However, how many times have you been searching through the Object Browser in QA or the left pane in Enterprise Manager searching for an object? New Author Ashish Kaushal gives us a method to easily search your server for that long lost object.
2004-08-17
19,381 reads
T-SQL is a powerful language, enabling you to handle many different types of set based operations. But having flexible WHERE clauses isn't something that many DBAs deal with on a daily basis. New Author Sotiris Filippidis brings us an article on how you can structure a WHERE clause to handle all types of strange business logic without using dynamic SQL. Read on to learn more about his technique.
2007-09-28 (first published: 2004-07-26)
40,182 reads
Using sysforeignkeys to discover SQL Server circular relationships. Have you ever tried this? Most of us probably haven't, but Jeffrey Yao often needs to reverse engineer databases for his clients. Here's a followup to his first article where he presents another of his techniques for doing a little detective work in your databases.
2004-06-30
7,124 reads
String manipulation in SQL Server or T-SQL can be a challenage. There are multiple ways to accomplish every task and often learning a new one may spark some creativity in yourself or teach you a better way to accomplish an old task. New Author Stephen Lasham brings us his technique for extracting a string that is delimited from within a larger string. Something I'm sure we'll all have use for in the future.
2004-06-14
23,371 reads
Error handling in SQL Server 2000 is tricky. And it isn't the most robust system in the world. Stefan Popovski started a series on error handling using @@error and xact_abort. Here's the second installment of this series looking at error handling in nested stored procedures.
2004-06-08
10,046 reads
The error handling in SQL Server leaves something to be desired, especially compared with other RDBMSes and languages. The standard method of testing for errors can leave your code bloated and hard to read. Stefan Popovski looks at another method of handling errors.
2004-04-21
8,377 reads
In this article by Steve Jones, he shows you how to manipulate strings.
2026-02-04 (first published: 2004-04-05)
17,845 reads
Dinesh looks at the date functions, how to work with time zones (or not), and does a brief comparison to see how you do similar tasks in Oracle.
2003-12-22
15,269 reads
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Are there any good articles on all the trace flags that are enabled on...
Comments posted to this topic are about the item The Data Model Matters
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers