admin posted on March 10, 2010 15:26
I learn something every day. Perusing the MSDN blogs, I noticed a cool one by Joe Sack that I wanted to make note of here... it doesn’t appear that Joe blogs a whole lot, but when he does, it’s usually worth reading.  This time he writes about the TSQL command ALTER INDEX ... [More]

Posted in: The Best of MSDN Blogs , TSQL  Tags:
Lee posted on February 9, 2010 16:19
IDENTITY discussion...again. Check out Aaron Bertrand's blog on the bad habits of haphazardly throwing IDENTITY attribute on a numeric field and calling it a primary key at http://sqlblog.com/blogs/aaron_bertrand/archive/2010/02/08/bad-habits-to-kick-putting-an-identity-column-on-every-table.aspx.&... [More]

Posted in: TSQL  Tags:
Interesting question about parameters. My good friend and super-stealth ninja middle-tier, business objects, BLL, DAL, bad*ss programmer Craig Boland asked me a question the other day about an oddity with stored procedures and functions. Eh, whassat you say? What’s a super-stealth ninja middle-tier... [More]

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:
Lee posted on December 15, 2009 09: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:
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]

Lee posted on December 7, 2009 11: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:
Lee posted on November 27, 2009 10: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 13: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:
Lee posted on November 9, 2009 18: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 18: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 4, 2009 09: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:
Admin posted on October 14, 2009 08:12
Back to the Julian date post   I was curious as to how this particular Julian date conversion worked; I hate implementing something without knowing why it worked. Pardon that blog, but offered no service to a reader without including an explanation, so I ask for forgiveness at this time. Norm... [More]

admin posted on October 8, 2009 20:19
Someone searched the site for this…let’s take a look A reader was looking the other day to find how they might find a percent character (percent sign, or %) within a string using the LIKE operator.  Check the code below.   USE tempd... [More]

Posted in: TSQL  Tags:
Lee posted on October 4, 2009 10:51
Needs additional flexibility in future releases   I got an idea to revisit the ability to optimize a LIKE query. These queries really can’t be optimized if the % is in front of the keyword, such as WHERE col LIKE ‘%Manager’ (to get the various types of managers), because the optimizer... [More]

Posted in: TSQL  Tags:
Lee posted on September 25, 2009 06:17
JD Edwards friendly.  Searching for “Date to Julian” on Google! will return 7,343,555 hits on a good day, but while such a cornucopia of awe-inspiring functions, scripts, and stored procedures are returned, I stil find that for JD Edwards this one works very well. I have no idea wh... [More]

by Lee Everest, M.S.

Search


Ads

Calendar

«  March 2010  »
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
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 2010 Lee Everest's SQL Server, etc. weblog