|
|
|
|
Got a SQL Server question that needs answering? SQLblog now has a SQL Server forum that can be found at http://sqlblog.com/forums/57/ShowForum.aspx.
Latest Blog Posts
-
|
It's a common practice for people who write T-SQL scripts to test each statement one at a time before finally running the entire script. This can lead to unexpected surprises. When each statement in a script is executed one at a time, each is separate...
|
-
|
SSIS is a pretty useful tool for designing ETL processes. One of the transformations I was disappointed with in 2005 was the lookup. I found it a little better than the lookup functionality in DTS, but not too much better. Well, Microsoft must have read...
|
-
|
I see people complain that IntelliSense (new in SQL Server 2008's Management Studio) is not working. Most of the time, it is for one of two reasons: The object is not in the local IntelliSense cache, since it was created recently. You can fix this easily...
|
-
|
Dell recently published a TPC-H report for the PowerEdge T610, 2 x Xeon 5570, with 4 FusionIO 80GB SSD storage devices at 100GB scale factor. So why have we not seen TPC-C or TPC-E OLTP benchmark results published? Now it is much more feasible to run...
|
-
|
I have made up a simple example when a CHECK constraint that uses a UDF should succeed but always fails. Suppose you need to move some stuff in your car, and you don't want to load more than 100 pounds into your small car at a time. Here is the DDL: CREATE...
|
-
|
As I prepare for my SQL PASS 2009 presentation "Solving the Bill of Materials Problem", I'm trying to make sure I use colors that are visible to people with colorblindness. I've found two tools to help accomplish this. Colorlab available at http://colorlab.wickline.org/colorblind/colorlab/...
|
-
|
One of the smaller events I try to get to each year is the Code Camp that happens in Adelaide ( www.codecampsa.com ). It might be smaller but I always enjoy it and I'm sure that Peter Griffiths and David Gardiner will be putting on a good show again this...
|
-
|
I have learned many things at every PASS Summit I have attended. First off, all of the people who are speakers are just human beings like you and me (including everyone's favorite Kalen Delaney). I learned that it is really expensive to put on a conference...
|
-
|
I remember my first PASS Summit in Denver in January 2002 (Delayed from Sep 2001 in Orlando due to Sep 11). One of the last sessions that I attended was led by Fabian Pascal. He runs a website called www.dbdebunk.com and is rather entertaining at times....
|
-
|
I have only been to one PASS Summit and it was the one in November 2008. If you had asked me last year this time about attending a large convention like PASS Summit, TechEd or SQL Connections, I would have told you to save your money for something more...
|
-
|
As organizations start to deploy various data grids into their application layers, they may start to experience what I’d call a SQL storm —a massive number of simple SQL requests that are issued over a large number of concurrent database connections at...
|
-
|
At the 2003 PASS Summit in Seattle the organization had a "SIG Challenge" that involved developing a database solution to a business problem. They assigned people to teams and allowed us to work on the problem only when sessions weren't occurring, but...
|
-
|
I have attended PASS for several years, and discovered at my very first event that this is an extremely valuable conference to attend. The actual technical tidbits I’ve learned from attending sessions and having conversations with my peers, PASS officials...
|
-
|
It was slim pickings this week. One item I thought deserved some attention was one that was filed a year ago today, and the rest are collectively related items involving ... ========================= Clustering Enhancements #353984 : Add support for multi-subnet...
|
-
|
In the SQL Server communities, it's common to hear people talking about HP SAN, EMC SAN, 3Par SAN, and so on as if there were such things as HP SAN, EMC SAN, etc. Technically, SAN stands for Storage Area Network, but can be, and has been, used in two...
|
-
|
<Updates at bottom of post> OK this will probably start a fire storm from Die- Hard Live Writer (LW) geeks but oh well :). I don’t blog as much as I would like and one reason is that I have had so much trouble getting posts properly formatted that...
|
-
|
I just had a situation in which we are automating the comparing of databases and I came across a bunch of Defaults that were never explicitly named. This causes them to get a new name each time you create them and makes it much more difficult to write...
|
-
|
I only recently discovered that SSMS will connect to different things. For instance, press the "New query" button. What were you connected to? The answer is the same server as your "current" server. But what is the current server? It is the server where...
|
-
|
If you have a multi-instance SQL Server 2005/2008 Server that is behind a firewall, and you want to be able to remotely connect to the DAC, you have to create firewall rules that allow the TCP ports for the DAC through the firewall. You can easily...
|
-
|
Surely this sounds like common knowledge, yet I decided to post a simple benchmark demonstrating how slow they are - in this case almost 100 times slower than a foreign key. Recently Pure Krome asked a question on stackoverflow about implementing subtypes...
|
There are
69 guest(s) online.
Currently there are no online users.
|
|
|
|
|