Browse by Tags

Why Format TSQL?

Recently I had the chance to help a student debug a problem on a production server. It appeared to be failing because duplicate uniqueidentifiers were being created. Thinking that unlikely because the G in GUID stands for global, we dug in but found the code painfully hard to follow due to poor formatting...

Posted to It Depends (Weblog) by Andy Warren on 06-29-2008
Microsoft BI Conference Oct 6-8, 2008

Had missed the announcement, came up in conversation yesterday with a friend, the BI conference will be Oct 6-8 in Seattle, registration is $995 if you register by Aug 8. Not planning to attend, so far I'm still firmly rooted on the conventional DBA side of things.

Posted to It Depends (Weblog) by Andy Warren on 06-23-2008
Notes on My Visit to Birmingham SQL Group

Spent last Tues/Wed in Birmingham, speaking at the user group Tuesday night and then presenting a seminar on Wed. Attendance at the user group was good, about 18, and had really nice participation as I did my standard presentation on transactional replication. They've only been back in business since...

Posted to It Depends (Weblog) by Andy Warren on 06-22-2008
XML Puzzle Contest Winners

In the last entry I promised to share the answer to the XML puzzle today. Here's a quick recap of the question - SQL 2005 BOL gives the following example of a full-text search XML thesaurus file: <XML ID="Microsoft Search Thesaurus"> <thesaurus xmlns="x-schema:tsSchema.xml">...

Posted to Pro SQL Server XML (Weblog) by Mike C on 06-20-2008
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: statements, and never really ask a question. An...

Posted to SQL Musings (Weblog) by Steve Jones on 06-18-2008
Trigger Notes

One of the questions that came up during a panel discussion at SQLSaturday #4 was whether it was better to have one trigger or many. It's a Zen question, no real right answer as far as I'm concerned. In practice having 7 update triggers is probably not a good idea, both from a raw performance...

Posted to It Depends (Weblog) by Andy Warren on 06-15-2008
Avoid Domain Admin level accounts for SQL Server

Every so often I see a post in the forums where someone has stated they've used a Domain Admin level account to run the SQL Server service. The implications are that anyone who is a member of the sysadmin fixed server role is effectively a domain admin. That means if a developer is a member of this...

Posted to K. Brian Kelley - Databases, Infrastructure, and Security (Weblog) by bkelley on 06-12-2008
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 as two things - Quality: Given the criteria, you...

Posted to SQL Musings (Weblog) by Steve Jones on 06-12-2008
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 optimized to run for the times where there are no...

Posted to SQL Musings (Weblog) by Steve Jones on 06-11-2008
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 saw a copy of the new one, to be released at TechEd...

Posted to SQL Musings (Weblog) by Steve Jones on 06-04-2008

Page 1 of 10 (93 items) 1 2 3 4 5 Next > ... Last »