Browse by Tags

All Tags » sql server (RSS)
Asking a SQL Question
I've been a little surprised lately by some of the questions I've seen in our forums at SQLServerCentral.com with questions that weren't questions. I've seen people post things that make it hard for people to help them. Among those items...

Posted 18 June 2008 10:17 by Steve Jones

Filed under:

TechEd - Query Performance
A program manager asked the question at the start: Who's had a query performance issue where a query "went bad" on the server? Lots of hands up, and that was one of the things I wanted from this session. What's reliability? MS sees this...

Posted 12 June 2008 08:17 by Steve Jones

TechEd - Data Corruption
I went to this one, mostly because I don't understand coruption that well and Paul Randal is a great speaker. Worth going to see him if you get the chance. Run CheckDB. It's important. You need to know how long checkdb takes to run. Checkdb is...

Posted 11 June 2008 08:23 by Steve Jones

A New Logo
For SQL Server, it's coming soon. Surprisingly, when I was up in Redmond, quite a few people were asking about this, and wanted to have a new logo. I somewhat agree that the old logo was a little tired and it would be good to see something new. I...

Posted 04 June 2008 10:22 by Steve Jones

Filed under:

Backups of Backups
After being gone for 4 days, I've got a little catching up to do. I try to be prepared before I leave, but I also like to be ahead of the curve, especially with the daily grind of articles, QODs, scripts, and of course, editorials. I took my video...

Posted 27 May 2008 11:28 by Steve Jones

Collation Issues
This is really interesting to me: CREATE TABLE #TEMP (name varchar(80)) INSERT INTO #TEMP values ('Malteser Schloßschule') INSERT INTO #TEMP values ('Malteser Schlossschule') CREATE TABLE #TEMP1 (name nvarchar(160)) INSERT INTO #TEMP1...

Posted 19 May 2008 10:48 by Steve Jones

The CLR
Some very interesting responses to my CLR editorial today including some good details that I haven't seen elsewhere. I'm still thinking that we're missing a lot of examples that might convince people to give the CLR a try, or implement it...

Posted 13 May 2008 16:18 by Steve Jones

Filed under: , ,

A View Variable
I saw that Erland Sommerskag posted a Connect item that asked for a "View Variable" to be added to the SQL language. The idea is that you would be able to declare a variable that was a query of some sort and then use that in places where you...

Posted 09 May 2008 19:52 by Steve Jones

Filed under: , ,

The Post Count
One of the things that I made a conscious effort to do last summer was make a regular effort to post in the forums at SQLServerCentral.com. I'd been neglecting them for a couple years, rarely tracking anything other than the Editorials, Suggestions...

Posted 01 May 2008 11:18 by Steve Jones

The MVP Summit
I hate to say it, but I can't say anything. At least not yet until I confirm some things are not under NDA. However it was a great week, I met some very smart people, and had a good time. Lots of things in the works for both SQL Server 10 (2008) and...

Posted 21 April 2008 18:13 by Steve Jones

Filed under: ,

MVP Day 2
Yesterday was an interesting day up at Microsoft. The SQL Server track is split into two sessions, with 2 assigned rooms, and luckily for me, all of the sessions I wanted to attend were in one room, so I never had to move. I liked that, though I was regretting...

Posted 16 April 2008 11:30 by Steve Jones

Filed under: ,

Fast
I am actually stunned. I knew that more bandwidth makes a difference, but having way more bandwidth is truly amazing. My daily upload routine, which actually ends up being anywhere from twice to 5 times a week for video, is to start uploading one video...

Posted 14 April 2008 16:50 by Steve Jones

Filed under: ,