Lee posted on November 27, 2009 12:15
Transactionless?  Really?  Hmm. Lets check to be sure.    Whilst geeking with table variables, waiting for turkey dinner to make its way to the dinner table,  I happened upon a blog or two about table variables being ‘transactionless’.  This spar... [More]

Admin posted on November 26, 2009 15:49
Geeking with table variables. Again.     Table variables have always been somewhat interesting to work with when developing in SQL Server. I remember when they came out in SQL Server 2000 we were all excited about trying them out, something new from SQL 7 that mainly sparked our in... [More]

Posted in: SQL Server 2008 , SQLServerPedia , TSQL  Tags:
Admin posted on November 26, 2009 08:57
Giving thanks to the readers of this blog.   Just wanted to take a moment and say: Happy Thanksgiving!  Whether you are or are not celebrating the Holiday, consider taking moment to give thanks. Whether you’re thankful for your family, friends, job, girlfriend, health, dog,&n... [More]

Lee posted on November 24, 2009 14:11
Chock full of handy items!   Another neat feature in SQL Server Management Studio 2008 (SSMS 2008) is the extended menu that you’ll find when you right-click on the query editor. You’ll find one that I really like – “Trace Query in SQL Server Profiler”.&nbs... [More]

This is pretty slick. Found another handy blog on MSDN...Here's a way to create a DSN-less connection in Microsoft Access, very nice!  Where I am consulting they use Access dbs to store static lookup information for their data marts/warehouses.  And since it's a global organization with s... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on November 23, 2009 11:37
SQL Rx performance evaluations.   John Paul Cook wrote a blog about the greatness SQL Risk and Health Assessment Program (SQLRAP) the other day, which prompted me to write a similar piece about ISI’s SQL Rx practice for performance tuning and server evaluations as an alternative to co... [More]

Lee posted on November 18, 2009 13:17
Goodies abound!     Has anyone else noticed that in the SQL Server Management Studio 2008 that you can now “Copy with Headers” out of the Results pane?  Great stuff!  I love how they keep improving the functionality of this tool; now we’re seeing some cool ... [More]

Verifying our results.   I received an email the other day from Kevin Stephenson, a SQL Server guru from the Microsoft SQL Server Customer Advisory Team, SQLCAT, who prompted my interest in the “Deleting Data Quickly…” series of blogs found on this site. Kevin mentio... [More]

Lee posted on November 16, 2009 14:34
An easy way to add them to your system.   I’m beginning to use environment variables more and more these days for SSIS and find it a pain to have to keep opening the system properties to get to them.  An easy way to set, list, or delete them is by using a simple vb script such as... [More]

Admin posted on November 15, 2009 07:28
Nice cheat sheet for SSIS. Douglas Laudenschlager found a cool SSIS expression cheat sheet located on the PragmaticWorks website; found a few cool things there so you might go check it out. A couple of things, they’ll require you to sign up at the site before you get the paper.   Lee... [More]

Lee posted on November 9, 2009 20:56
Effective, simple, and fun.   I always enjoy doing some ‘practical bitmasking’ whenever I can, if for no other reason than to show someone that there are some cool situations to use the technique. If you’ve happened to catch some of my other blogs or presentations on bitmask... [More]

Lee posted on November 6, 2009 20:14
Making 'dynamic' even more dynamic In this month’s SQL Server Magazine (11/2009) an article was featured on the concept of dynamic pivot.  This was of interest to me because, since I peruse the stats on how people arrive at this site, I have seen several searches from Google! looking f... [More]

Lee posted on November 5, 2009 08:14
New Sharepoint book - decent read.  Saw a blog on the MDSN blog site today that pointed to a new whitepaper/online book on Sharepoint administration for SQL Server DBAs. Thought that this might be worthwhile read since every Sharepoint site that you’ve ever been on is slower than molass... [More]

Lee posted on November 4, 2009 11:13
Schemas give us some options.        Someone posed the question the other day…”Can you have a constraint with the same name multiple times in a database?”  The answer is, of course, yes.  Because schemas are available, you can create constraints ... [More]

Posted in: SQL Server 2008 , TSQL  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