create table MyTable (id int)
go
Create Table #Test (id int)
go
create proc MyProc
   @id int
as
  insert MyTable select @id
  insert #test select @id
return
go
exec MyProc 2
go
select * from #test
go
drop table MyTable
drop procedure MyProc

I saw a question recently about temp… Read more

It’s probably a key stereotype of our business that the sales team doesn’t really get along with those in operations/production. Sales teams seem to insist on selling features and timelines without asking if it’s even close to possible, and operations wants to solve problems elegantly without regard to the realities… Read more

OK, there was something that Microsoft did to tick me off.  SQL Server 2005 introduced us to so many exciting and useful DMVs, such as sys.dm_os_sys_info.  This DMV, which would give us a set of useful information about the computer, and about the resources available to and… Read more

The SSIS Package Store is a nice option available for storing SSIS packages.  The Package Store lists packages stored on the server in the MSDB folder and all packages stored on the file system as long as they are in the default folder (C:\Program Files\Microsoft SQL Server\100\DTS\Packages for SQL 2008)… Read more

I stumbled on this article about a spin-off from MIT using solar power to create hydrogen. I think it's a great idea, one that I'd like to have working in my house, but it's not as simple as having a storage tank and a solar panel.

To me this… Read more

Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going to charity. The book consists of over 50 chapters, each on a different SQL-Server related topic, from database architecture through development administration, database development, performance tuning and even Business Intelligence.… Read more

I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9 different cities. I began my journey from my home, on the Big Island of Hawaii at 9:30 AM on Saturday, and arrived in Sydney at 8:30 PM on Sunday. Hawaii… Read more

If you are available for lunch today don’t forget to sign in and watch Thomas LeBlanc talk about Historical DMV information.  To attend the meeting use this URL:  https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend.  Also, if you would like to receive notifications about upcoming SQL Lunches register here:  http://www.tsqlscripts.com/SQLLunch.aspx. 

See you at Lunch Read more

I have been installing and configuring SSRS since the initial release.  I have always encountered several different caveats when upgrading to a newer version or adding a new server to a scale-out deployment.  In some cases there have been consistencies, but in many these differences vary.  These variances may have… Read more

I actually got back from camping Sat night, but since I wasn’t scheduled to come back until Sun afternoon, I avoided the computer. I let both the desktop and laptop remain at idle, not even checking personal email until Sun night.

When I checked Sun night, I saw a newsletter… Read more

It seems that often I see posts that say “I’m out of space on my drive, what do I do?” The answer, as with most anything in SQL Server is, it depends.

Backups

The most common issue I see for running out of space is the lack of deleting database… Read more

I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9 different cities. I began my journey from my home, on the Big Island of Hawaii at 9:30 AM on Saturday, and arrived in Sydney at 8:30 PM on Sunday.… Read more

I saw this post by Neil Davidson about sales people being different that discusses how sales people are compensated and why he is moving to a salary model instead of commission. I’ve never been a sales person, but I’ve had the interesting time of working with them at a mid… Read more

I was asked recently by Chris Shaw who is the site manager for SSWUG.org, if I was interested in speaking at the upcoming vConference.   I was thrilled to have been asked as I've been wanting to do more community activities. I went out to the speakers list and my… Read more

Cross posted from The Goal Keeping DBA:

Read more

I just realized that blogs will soon be obsolete artifacts. Let me explain why:

• For over 10 thousand years “writing, painting and talking” have been the most basic communication tools we use to describe our lives. In the early computing days storage was very limited; I remember tools like…

Read more

It had been about 5 years since I’d bought a new desktop machine for my home, and with my oldest starting school this year, it was time to add another computer to our inventory.  Since my son’s computer needs are relatively minimal at this point, I decided to buy a… Read more

There was a time when health information was merely a collection of facts about you. You visited a doctor on the 17th because of a sore throat.  You had your appendix removed when you were a grade-schooler.

Now, in the 21st century, information is increasingly used to drive business value.… Read more

Gail Shaw, who is a SQL MVP from South Africa, has an excellent blog post about this subject.

The executive summary is that having lots of conditional logic in a stored procedure tends to confuse the SQL query optimizer and it often causes problems with parameter sniffing. Parameter sniffing is…

Read more

Date: 9/28/2009

Time: 11:30 AM

Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=F7DRFD&role=attend

Presenter: Thomas LeBlanc. Thomas is a Database Administrator for Amedisys, Inc in Baton Rouge, LA. He has been in the IT field for 20 years starting as a COBOL programmer, graduating to dBase, FoxPro, Visual FoxPro, VB 3 thru 6 and… Read more