So I just got a brand new shiny QuadCore PC with 6GB of RAM and Vista on it. I decided to setup ReadyBoost since I have a couple of USB dongles laying around. How does ReadyBoost work? Here is what Wikipedia has to say Using ReadyBoost-capable flash memory (NAND memory devices) for caching allows Windows Vista to service random disk reads with performance that is typically 80-100 times faster than random reads from traditional hard drives.
This is an archive of the posts published to LessThanDot from 2008 to 2018, over a decade of useful content. While we're no longer adding new content, we still receive a lot of visitors and wanted to make sure the content didn't disappear forever.
I’m sure one of us already Wiki’d this or put it in a blog but since I just had to weed through some code to figure out why something wasn’t working I figured I’d say it again. PLEASE and I stress, PLEASE, make sure you initialize your variable in TSQL or at the least, use IsNull or coalesce to prevent this famous and all annoying issue from killing your hard work
SQL Server profile is misleading when you look at it under the All Programs listing. It states that SQL Server Profile is part of the, “Performance Tools” set. OK, yeah it really is primarily a performance tool for DBAs. There’s something else that it does though that is a pretty handy friend when either writing reports on third party databases or trouble shooting issues with application not functioning. Let’s say a user comes to you and asks for a report “just” like that one in “this” screen.
Yesterday I had a bad day. My build on the buildserver wouldn’t run. For some mysterious reason VS decided to crash when the solution was opened with the very famous “System Error &He06d7363&” which even Google can’t seem to find. My build machine happens to be on XP (VM) and my developing machine is on Vista 64 bits. So after searching for at least half a day, I got the brilliant idea of reinstalling the VS2008 SP1 and that fixed the problem ;-).
If you ever replicate tables that have identity seeds on columns you’re more than likely going to have a headache on your first try of setting this up. There are several things you have to consider and take into account when replicating these types of columns. Of course you want them replicated and you can very easily do so while retaining the integrity between the tables. However, if you ever remove replication from the subscriber table, you’re going to find yourself in a sticky situation no matter what setting you have for the replication.
Your testbed has to have the same volume of data as on production otherwise you are not really testing anything. This blogpost is kind of a rant after I noticed this post on Stackoverflow I do not believe there is a problem with the create trigger statement itself. The create trigger statement was successful and quick in a test environment, and the trigger works correctly when rows are inserted/updated to the table.
Today is the one year anniversary of Less Than Dot, I cannot believe this, time is flying by so fast. I would like to list some stats about the site and also list the most popular blogposts, wiki pages and forum posts. First the site stats. Browsers Firefox 53.05% Internet Explorer 35.14% Chrome 5.12% Safari 3.
Often I hear the argument on log shipping for disaster recovery not being a good choice due to the difficulty in failing back to the primary site. I never really got this argument and enjoy it when people try to bring it up when trying to sell expensive third party tools to replicate off-site. Of course if you have the money, there are far better choices to get your data to the DR site.
If you are anything like me, you have about 4 or 5 instances installed on your laptop. Needless to say this can be a pain in the rear. Today I was blogging on replication and affects on identity seeds and wanted to use my default instance installed locally to test everything in order to provide the exact scenario to my readers. Well, that didn’t go so well. First problem. I couldn’t configure the distributor
I answered this question a while back and decided to create a little blogpost. Let’s say you have the following datetime values 2009-05-12 11:13:19.667 2009-05-12 11:12:19.667 2009-05-12 11:33:19.667 2009-05-12 11:43:19.667 2009-05-12 11:03:19.667 2009-05-12 11:53:19.667 2009-05-12 11:53:19.667 2009-05-12 11:23:19.667 2009-05-12 12:13:19.667 2009-05-12 12:12:19.667 2009-05-12 13:33:19.667 2009-05-12 13:43:19.667 2009-05-12 14:03:19.667 2009-05-12 14:53:19.667 2009-05-12 15:53:19.667 2009-05-12 15:23:19.667 What you want to do is break them into half hour blocks and count them, your output should look like this