A view is most commonly thought of as a SELECT statement. Most developers will simply create a view to "group" complex SELECT statements for reuse within another view or stored procedures. It makes typing easier! But the really power of views is their ability to implement business rules.
2007-04-23
4,528 reads
Use SQL Server Profiler to “look behind the scenes” within Analysis Services 2005. BI Architect Bill Pearson leads a hands-on introduction to determining resource utilization effectiveness for both processing and query performance with profiling.
2007-04-19
2,790 reads
Should you store dynamically generated web-site graphics in a database or is the file system the better option? Dino illustrates how to make this decision in ASP.NET
2007-04-17
3,883 reads
If you're like me and find XML a bit of an acronym minefield, Robyn Page's Cribsheet will help sort out your XSLT from your XDM.
2007-04-16
2,866 reads
With the release of SQL Server Everywhere Edition looming, Scott sits down with Mark Jewett and Steve Lasker to find out about Microsoft's new database engine.
2007-04-13
4,161 reads
For those times when you absolutely, positively got to perform a cross tab query in SQL, Keith Fletcher's T-SQL stored procedure will allow you to do it "on the fly". You can add it to your database and start cross tabbing immediately, without any further setup or changes to you SQL code. Check it out, and then take the cross tab challenge.
2007-04-11
4,992 reads
The NEWSEQUENTIALID system function is an addition to SQL Server 2005. It seeks to bring together, what used to be, conflicting requirements in SQL Server 2000; namely identity-level insert performance and globally unique values.
2007-04-10
2,884 reads
SQL Server 2005 has so many new features that in my opinion if you read only BOL for a year you'd find something new every day. One of those is Multiple Active Result Sets or MARS. Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.
2007-04-09
2,563 reads
What's the best way to change the default backup directory for a server, using SSMS or Enterprise Manager, without changing all the default directories at the same time? What is the TSQL to do it? A prize for the best correct solution.
2007-04-06
3,467 reads
Having been at the sharp end of many successful SQL Server solutions, I believe there are some fundamental principles that all successful SQL Server installations have in common. Whilst the challenges in delivering an enterprise-scale database-intensive application can be wide and varied, there are a few basic practises that will give you the best possible chance of success.
2007-04-05
2,570 reads
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
By Brian Kelley
Just as it's important to take care of our physical health (and I'm guilty...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A
SELECT
a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
Person.Address a
INNER JOIN person.Person AS p
ON p.rowguid = a.rowguid
WHERE
City = 'SEATTLE'
AND PostalCode = 98104
OPTION (QUERYTRACEON 4199, 4137);
-- B
SELECT
a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
Person.Address a
INNER JOIN person.Person AS p
ON p.rowguid = a.rowguid
WHERE
City = 'SEATTLE'
AND PostalCode = 98104
OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137);
-- C
SELECT
a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
Person.Address a
INNER JOIN person.Person AS p
ON p.rowguid = a.rowguid
WHERE
City = 'SEATTLE'
AND PostalCode = 98104
OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);
See possible answers