In SQL Server 2005, object ownership will have a different meaning, but since most of us work with SQL Server 2000, Kathi Kellenberger has written a good introduction to understanding how object ownership works and why you might want to follow certain practices.
2007-10-02 (first published: 2005-07-18)
54,897 reads
One other use of the new CLR integration in SQL Server 2005 is the ability to create user defined data types using managed code. Author Dinesh Priyankara brings us a first look at this capability with some code you can use.
2007-10-02 (first published: 2005-08-02)
35,943 reads
SQL Server 2000 added XML support awhile back, though it was limited in what is offered and can be a little confusing. SQL Server 2005 will add many more features and functions, but in the meantime, if you are looking to add some XML support to your 2000 server, new author Raj Vasant brings us some basics on using OpenXML.
2007-10-02 (first published: 2005-05-12)
42,931 reads
Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL.
2007-10-02 (first published: 2001-07-16)
23,965 reads
I have always read that 8060 bytes is the maximum size. This is stated over and over again in Books Online, the MS site and numerous other sites, including this one. However a post in our forum recently questioned this. I decided to verify the problem and do a little research.
2007-10-02 (first published: 2002-02-07)
37,509 reads
Datetime data in SQL Server can be a little confusing to work with, especially as many front end languages do not combine the date and time into a single datatype. As a result, T-SQL is sometimes used to manipulate and convert datetime data into more useable formats. Author Leo Peysakhovich has written about some tricks that he uses to reformat and work with datetime data.
2007-10-02 (first published: 2004-12-22)
29,318 reads
Will changing to bulk recovery mode before running DBCC REINDEX help you avoid large log files? András investigates
2007-10-02
2,168 reads
Collaboration between IT and the business will help identify the reasonable issues versus the issues that cannot be resolved for the current release of the data warehouse.
2007-10-02
2,482 reads
Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring!
2007-10-01 (first published: 2003-08-13)
54,173 reads
The Sarbanes-Oxley act has drastically changed the jobs of many DBAs with the audit and reporting requirements this act entails. Brandie Tarvin brings us some hints about how you can go about complying with the new requirements.
2007-10-01
3,803 reads
Every organization I talk to has the same problem dressed up in different clothes....
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Comments posted to this topic are about the item The day-to-day pressures of a...
Hello all, I’m looking for advice on how to derive a daily snapshot table...
We need to replace our Windows server running SQL 2017. Any reason not to...
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription 1 Becks Interbrew Beck's is a German-style pilsner beer 2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness. 3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste 4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer 8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beerIf I run this, what is returned?
select t1.[key]
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers