Geeking with sp_.   WHAT’S IN A NAME? We have all heard that prefixing SQL Server stored procedures with “sp_” is a no-no; you have probably read the many reasons not to do this, but the most familiar ones to developers are that 1) Microsoft uses the “sp_” naming convention for their syste... [More]

Posted in: SQLServerPedia , TSQL  Tags:
admin posted on December 28, 2009 09:35
A nice series to check out.   Here is a cool set of SSIS best-practice articles that I found on the MSDN blog site; you might check these out if you’re looking for some tips on making SSIS run well.  I found a few things that were pretty interesting and recommend the reading. http://blo... [More]

Posted in: The Best of MSDN Blogs , SSIS  Tags:
Lee posted on December 24, 2009 11:51
These vids are really great!  The folks at SQL Share do a really nice job with their quick 2-minute videos series on SQL Server topics.  I really like the depth and breath of these short snippets, and is just right for some of the basic tasks when either doing development or ad... [More]

SSIS 2005 errors...glad many go away with SSIS 2008   It’s amazing to me on just how much better, nicer running, and less clunky SQL Server Integration Services (SSIS) 2008 is over its’ SQL Server 2005 counterpart. Every time I (have to) open it up – usually because client v... [More]

Posted in: SSIS  Tags:
Lee posted on December 20, 2009 08:03
If it's not your work, it's not your work. I never paid much attention to the several articles out on the web about plagiarism with respect to SQL Server, blogs, etc., that is, until it happened to me. About a year ago I did a really cool blog on an interesting idea, and a month or so later, there ... [More]

This is a jim-dandy. You gotta read this one.    So I’m once again perusing the MSDN blogs looking for great stuff when I come across one from the CSS SQL Server Engineers about DBMail suddenly stops working (1).  This is significant because everybody and their dog uses sp_sen... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on December 15, 2009 11:56
Oops. Someone forgot to include it. tablediff.exe was, from all acounts, inadvertently left out of the SQL Server 2008 install, so you’ll need to use the version from SQL Server 2005. I just checked two of my installs and couldn’t find it.  Thanks, whoever you were, for ... [More]

We have it. Might as well use it.   I found a really cool way to use the sql_variant type the other day, but ran into a problem using SQL Server and Microsoft Access. The client where I am located stores lookup data in Access, and then pushes the data from a .mdb into many client databases ... [More]

Posted in: SQL Server 2008 , TSQL  Tags:
Admin posted on December 11, 2009 18:00
Learned something new today.   At my current client I have the opportunity to work with a scheduler by the name of Control-M, a product from bmcsoftware.  If you’ve never “developed” using a dedicated scheduling tool, then you were like me as of yesterday.  And I&r... [More]

Geeking with table variables. Again.     Table variables vs. Temporary tables. Ugh, here we go again   You often hear discussions on table variables and temporary tables in SQL Server, many of which relate to performance, which one is faster, when to use either based on t... [More]

Someone jumped the gun again. If you try to install the VS 2008 GDR R2 download and you receive this...  You probably need to get another operating system, preferrably an old one.  This is the download for VS that provides support for SQL Server 2008, as well as Team Edition f... [More]

Lee posted on December 7, 2009 13:15
Geeking with sql_variant. I found a really cool way use on the sql_variant type that I need to post, but wanted to share one thing that I saw today.  Run the following script in SQL Server 2008:  IF OBJECT_ID ('test') IS NOT NULL       DROP TABLE testGO&nb... [More]

Posted in: TSQL  Tags:
Admin posted on December 4, 2009 22:15
There is a reason why UDFs kill performance   Saw a great blog post [1] on the MSDN blogs regarding query tuning with UDFs; specifically the problem that was addressed is one that many of us have had to deal with, which is having to overcome the effects of a UDF in the WHERE clause of a ... [More]

Error when trying to install Windows Error. The image file __ is valid, but is for a machine type other than the current machine If you happen upon this error, then you are probably trying to install a 64 bit ISO while the server the server is running a 32 bit operating system. In order to move u... [More]

Posted in: Etc. (Off-topic)  Tags:

by Lee Everest, M.S.

Info

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog