quote:

---

http://www.sqlservercentral.com/scripts/contributions/26.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

---

Wrapping VLFs like this is unnecessary...

Unless you override by using DBCC SHRINKFILE with the target size option, you cannot reduce the file size below its originally configured size. (The default size for the log...

quote:

---

Funny you should ask. Turns out the biggest table, and the one I was working with did not have a clustered...

This is the right approach to determining how many disks to configure. The correct number of drives has little to do with total capacity when optimizing a server for...

quote:

---

I'm a little confused with respect to partitioned views.

Let's say I have a series of tables that contain quarterly data (ie. Subscriber_2002_Q1,...

quote:

---

Am I right?

---

Yes. Last time I calculated this, Ultra3 bus speed (160MB/s, not Mb/s)...

http://www.moshannon.com/speedferret.html

--Jonathan

This has got to be dynamic SQL, so you could just try:

DECLARE @sql varchar(800)

SET @sql = 'SELECT AccountId FROM Ca' + ISNULL(' WHERE CSId in (' + @GMCSids + ')','')

EXEC(@sql)

--Jonathan

Do not send concatenated code like that from VB. Use typed parameters for the values, preferably with stored procedures. That will not only prevent these issues, but it...

Use ALTER DATABASE as explained in

http://support.microsoft.com/default.aspx?kbid=224071

--Jonathan

Other than collations (used for strings), the data in SQL Server is not stored in any region-specific format. Your application should use the regional settings of the workstation. ...

It's very hard to read your trigger pseudo code, particularly as it does not match your pseudo DDL. Based on your narrative, I suppose you want something like this:

CREATE...

This is in BOL (acdata.chm::/ac_8_qd_14_8k6m.htm):

CREATE PROCEDURE sp_hexadecimal

@binvalue varbinary(255),

@hexvalue varchar(255) OUTPUT

AS

DECLARE @charvalue varchar(255)

DECLARE @i int

DECLARE @length int

DECLARE @hexstring char(16)

SELECT @charvalue = '0x'

SELECT @i...

quote:

---

Thanks Jonathan but it is not what I am looking for.

Min(OrderDate) and Max(OrderDate) only works if you assume that Northwind does not...

SELECT EmployeeId, MIN(OrderDate) FirstDate, MAX(OrderDate) LastDate

FROM Orders

GROUP BY EmployeeId

ORDER BY EmployeeId

--Jonathan