Direct access to MDF/LDF files while the server is running?  Are you thinking about updates, or just read-only?  And after you've figured out how to hook in to...

The RAND function only executes once per query...no matter how you write it all rows will have the same result.

The common way to randomize in T-SQL is to use the...

You could use an INSTEAD OF INSERT trigger to calculate the next sequence number:

CREATE TRIGGER trNextSeqNo ON ARTrans INSTEAD OF INSERT

AS

BEGIN

   INSERT INTO ARTrans (RefNo, SeqNo, ...)

   SELECT i.RefNo, ISNULL(NewSeq,...

INSERT INTO Table1 ( [Application Field], CountOfApplication )

SELECT Application, COUNT(*)

FROM Software

WHERE Application NOT IN (SELECT [Application Field] FROM Table1)

GROUP BY Application

You have to define computed columns in a subquery to be able to use the column (by alias) in the GROUP BY clause.  The aggregate functions stay in the main...

I've got "Visual Basic .NET and SQL Server 2000" from Wrox.  Is that specific enough?

Go to Wrox, Microsoft Press, or another technical publisher.  Or go to Amazon.  Either way, you'll...

The NEWID() function gets a new GUID value from the operating system, and on Windows 2000 or later is very random ("very" meaning better than the typical 16-bit RND() function...

The profiler graphic interface is very resource-intensive, so you can take some of the load off the server by running profiler on another computer.

Another question would be what you mean...

I was under the impression that DataEnvironment properties were set at design time.  I wouldn't be surprised to find that you can dynamically reconfigure the DataEnvironment at runtime, but my...

You can also use the INFORMATION_SCHEMA views to get metadata.

select IS_NULLABLE from information_schema.columns

where table_name = 'table' and column_name = 'column'

This returns 'Yes' or 'No'.

This view is simply looking at syscolumns.isnullable, but...

I didn't read every linked response, but standard spherical geometry seems to be a popular approach.  Unfortunately, this can be inaccurate for short distances (around 10 miles or less) as the...

I like to move common subexpressions to subqueries.  I find it easier to read, but I don't know that this version would be any faster.  Your statistics show that the greatest number...

I think dBase liked to use .DAT and .NDX for data and index files.  The .GLM doesn't ring a bell though.

You need multiple joins to look up different rows

SELECT Productions.ProductionID, Productions.ProductionTitle, Productions.ProductionType, Productions.ProductionClass, Productions.Award,

   r1.LookName as AwardName,

   r2.LookName as ClassName,

   r3.LookName as TypeName

FROM Productions p

INNER JOIN Ref_Look r1 ON r1.LookID =...

This function is not available in the Beta2 version of Yukon, but it is supposed to be in the release version.