Click here to monitor SSC

2007 September


Brian Donahue

Database backup: insufficient resources for cache withdrawal

1 comment

Sometimes SQL Server can pose conundrums of such complexity that even the Riddler couldn’t conceive of. In my mind’s eye, a SQL Server is in fact its’ own operating system, running on another operating system. For instance, SQL Server has a task scheduler to manage threads running within the SQL Server Process, and this User-Mode Scheduler […]

30 September 2007 12:40 pm by
Richard Mitchell

SQL Data Compare 6 RC1 – oh yes indeedy!

1 comment

You’ve been waiting for it, we’ve been working on it and finally the day has arrived. SQL Data Compare 6 RC1 is available for download Right Now!Download RC1 here…We’ve very proud of what we’ve achieved with this release. You can compare to backups even better than you could in the Alpha. We’ve finished off all […]

26 September 2007 8:41 am by
Phil Factor

Enumerating Group Members

3 comments

/* Problem: You have a table like this, recording what people eat. jane   pie fred   sandwich fred   sausage fred   biscuits jane   cake Rajiv  pastie Rajiv Croissants You want it to look like this… jane   pie, cake fred   sandwich, sausage, biscuits Rajiv  pastie, Croissants or maybe even you have the latter and you want the former! Robyn and I showed how this sort of thing was done in the SQL ServerGrouping Workbench under the title ’enumerating group members’. Let’suse a slightly more complicated example to show how it is done…. */ CREATE TABLE #schedule  (  EventStart DATETIME,  description VARCHAR(2000)  ) /* so now we can get some sample data into the table */ INSERT INTO #schedule ( EventStart, description )   SELECT ’12 Oct 2007 10:00′, ‘Meeting with Bill’ INSERT INTO #schedule ( EventStart, description )   SELECT ’12 Oct 2007 12:00′, ‘visit Crawley site’ INSERT INTO #schedule ( EventStart, description )   SELECT ’12 Oct 2007 13:00′, ‘Lunch with Evelyn’ INSERT INTO #schedule ( EventStart, description )   SELECT ’12 Oct 2007 14:00′, ‘Review of CDW27′ INSERT INTO #schedule ( EventStart, description )   SELECT ’12 Oct 2007 17:00′, ‘admin’ INSERT INTO #schedule ( EventStart, description )   SELECT ’13 Oct 2007 10:00′, ‘Finance committee’ INSERT INTO #schedule ( EventStart, description )   SELECT ’13 Oct 2007 12:00′, ‘lunch with Bob’ INSERT INTO #schedule ( EventStart, description )   SELECT ’13 Oct 2007 14:00′, ‘Weekly SH meeting’ INSERT INTO #schedule ( EventStart, description )   SELECT ’14 Oct 2007 11:00′, ‘interviews’ INSERT INTO #schedule ( EventStart, description )   SELECT ’14 Oct 2007 15:00′, ‘office plan presentation’ INSERT INTO #schedule ( EventStart, description )   SELECT ’14 Oct 2007 16:00′, ‘performance reviews’ /* now we produce the report that enumerates the group members */ DECLARE @list VARCHAR(8000)  SELECT @List = COALESCE(@list + ‘,’, ”) + ‘|’                   + CONVERT(CHAR(11), eventStart, 113) + ‘| ’                   + RIGHT(CONVERT(CHAR(17), eventStart, 113), 5)                   + ‘ - ’ + description + ‘|’                   + CONVERT(CHAR(11), eventStart, 113) + ‘|’ FROM #schedule ORDER BY eventstart […]

25 September 2007 4:20 am by
Andras Belokosztolszki

The GO command can have a parameter?

2 comments

I have mixed feelings about the GO command. It is not a T-SQL statement, it is just something that Management Studio and the other SQL Server tools understand as a batch separator command. Indeed, you can change it to whatever you wish in Management Studio under Tools->Options->Query Execution->SQL Server->General->Batch separator.So you can write queries like […]

24 September 2007 7:57 am by
Tim Ford

PASS Day 3: Hello Muddah, Hello Faddah

0 comments

Here it is, the last day of PASS 2007 and I find myself in a melancholy that comes with the last day of summer camps from many years past.  We are all far past the stage of being exhausted, yet not ready to seek out the family come to collect me and take that long […]

23 September 2007 12:25 pm by
Tim Ford

PASS Day Two: You Can’t Get There From Here (A Geog-DUH-phy Lesson)

0 comments

Here it is day two and I am finally starting to get adjusted to the time difference. Wimp. Sure, I thought I had it bad.  Two entire time zones between my native Michigan and Denver.  I always lose touch with just how global PASS is.  I was attending Peter Ward’s fantastic spotlight session on Engineering for the […]

21 September 2007 9:23 am by
Richard Mitchell

iPodtastic

0 comments

Just to let you know that we’re contacting the people who’ve helped out with the SQL Data Compare 6 Alpha and are in the process of getting your likkle iPods to you as I speak.Thanks to everybody who helped out, the release is looking really good now, we’re just doing a few last bug fixes […]

21 September 2007 7:13 am by
Brian Donahue

How to rewind a SQL Server

1 comment

I work for a company that sells software. And SOME people, because of their untrusing nature, need to be convinced that the software that we want to sell them actually works. This process, in some large, bureaucratic institutions, involves salesmen and conference calls and schmoozing and all of those things, that I, as a technical […]

20 September 2007 4:11 am by
Tim Ford

It’s PASS 2007 Arg!

0 comments

Volunteer meetings, PASS business, PASS SIG Quizbowl, Welcome Reception, SQL Server Central Party and the subsequent after party and after-after party, General Session and four breakout sessions and man is my brain tired! It’s all just a part of being at PASS and being involved in PASS.  Sure it is a great deal of work, but […]

19 September 2007 5:39 pm by
Robert Chipperfield

Can you Break The Code?

5 comments

Fancy winning some cool goodies? Red Gate has just launched its “Break The Code” prize draw, where you can win one of the following prizes: A year’s subscription to Safari Books Online (worth $550) One ANTS Profiler Pro license (worth $495) Red Gate goodiesAll you need to do is figure out how to decode the […]

19 September 2007 5:22 am by
Older posts