THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Browse by Tags

All Tags » SQL Server   (RSS)
Showing page 1 of 10 (93 total posts)
  • Cube collection error -

    Suddenly seeing a brand new error connecting to SQL 2000 cubes in a single OLAP database - the other databases don't throw the error.  Searches online have turned up nothing.  From Excel, the messages looks like this: ''Excel was unable to get necessary information about this cube.  The cube might have been reorganized or changed ...
    Posted to SQL Server (Forum) by hfulks on July 3, 2008
  • Fun with DBCC CHECKIDENT

    <Denis Gobo’s mode on> Suppose you have an empty table:   SELECT COUNT(*) FROM SampleTable --- 0   What would be the result of the following query:   DBCC CHECKIDENT('SampleTable', RESEED, 1) INSERT SampleTable(j) SELECT 1 SELECT SCOPE_IDENTITY()   <Denis Gobo’s mode ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 26, 2008
  • Re: Performance issues with MARS with more than 10 logical connection

    10 logical connections is a hard limit (see http://blogs.msdn.com/angelsb/archive/2005/01/13/352718.aspx and http://blogs.msdn.com/angelsb/archive/2004/09/07/226597.aspx for more details). If you go over this limit, it gets expensive from a performance standpoint. Also see ...
    Posted to SQL Server (Forum) by Peter DeBetta on June 26, 2008
  • Database Unit Testing: Impersonation

     When you run NUnit/C# unit tests against your local instance, you are a dbo. As such, you are not getting any errors caused by missing permissions. However, you can impersonate another user, and run your unit tests in the context of that other user. The following test harness demonstrates the ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 18, 2008
  • Database Edition Now Does DB2!

    Tech Ed 2008 included some major announcements for database development folks. One of the biggees was this - and announcement that Database Edition is going to support DB2 development! Gert and the team have been working hard to expand the underlying architecture and functionality of Database Edition (making it extrememly difficult for ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 16, 2008
  • It's all about the data...

    I read a very interesting post on Kimberly Tripp's blog which was about indexing, but she had a very interesting set of requirements for good indexing that I think apply to everything when designing, tuning, backing up, etc., any database. What strikes me the most are 1) and 2) - how can you tune any sort of system if you don't really know ...
    Posted to James Luetkehoelter (Weblog) by James Luetkehoelter on June 16, 2008
  • New E-Book: Mastering Database Edition Volume 1

    My first e-book is out! Mastering VS 2008 Team System Database Edition, Vol 1: Creating and Deploying Database Projects is available at Solid Quality Press. Volume 1 of the Mastering Visual Studio 2008 Team System Database Edition series focuses on creating and deploying database projects. The goal of the manuscript is to provide ...
    Posted to Andy Leonard (Weblog) by andyleonard on June 11, 2008
  • Unit Testing Tips: Reproduce a Lock Timeout

    Well, I have just finished a series of articles about unit testing on simple-talk.com, and some techniques were not included, just to keep the articles short. Still problems such as reproducing a lock timeout and unit testing the retry after it (lock timeout) are interesting, at least to me, so I am continuing. You will need the ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on May 30, 2008
  • Interview With Erland Sommarskog About SQL Server and Transact SQL

    I asked for some names of people who you would like to see interviewed here at Sqlblog and Erland Sommarskog's name popped up a couple of times. I contacted Erland and he was kind enough to take time out from his busy schedule to answer these questions.  So, here are the questions. What are the most important things a person can do ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on May 27, 2008
  • Boise SQL Server User Group

    The newly formed Boise SQL Server User Group kicks off its first meeting with Kalen Delaney on June 25, 2008. I'm happy to see a Microsoft SQL Server user group in Boise. It will fit nicely with the other development and SharePoint groups in town. For more information, contact Cindy Gross of Microsoft.
    Posted to Richard Hundhausen: The DBAgilist (Weblog) by Anonymous on May 1, 2008
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement