Temp tables and scope
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...
2009-09-29
1,706 reads
Sales vs Operations
It’s probably a key stereotype of our business that the sales team doesn’t really get along with those in operations/production....
2009-09-28
958 reads
Don't Tick Me Off...CPU Ticks
OK, there was something that Microsoft did to tick me off. SQL Server 2005 introduced us to so many exciting...
2009-09-28
6,207 reads
Adding a folder to the SSIS Package Store
The SSIS Package Store is a nice option available for storing SSIS packages. The Package Store lists packages stored on...
2009-09-28
6,355 reads
Storing the Sun's Energy - Solar Power
I stumbled on this article about a spin-off from MIT using solar power to create hydrogen. I think it's a...
2009-09-28
1,103 reads
MVP book is available for preorder
Last year a large number of MVPs (mostly SQL Server) got together to write a book with all proceeds going...
2009-09-28
572 reads
Arrive in Sydney To Begin 30-Day Australia & New Zealand Speaking Tour
I’ve just began my 30-day tour of Australia and New Zealand, where I will be making 11 presentations in 9...
2009-09-28
428 reads
SQL Lunch Starting at 11:30 CST
If you are available for lunch today don’t forget to sign in and watch Thomas LeBlanc talk about Historical DMV...
2009-09-28
595 reads
Reporting Services - Disable Loop Back Check
I have been installing and configuring SSRS since the initial release. I have always encountered several different caveats when upgrading...
2009-09-28
5,228 reads
Back From Vacation and Making a Big Mistake
I actually got back from camping Sat night, but since I wasn’t scheduled to come back until Sun afternoon, I...
2009-09-28
662 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat Telp BCA KCP Benhil +62 838-4945-0961
Wa:083849450961 Jl. Bendungan Hilir No. 44/I, RT.8/RW.1, Bend. Hilir, Kecamatan Tanah Abang, Kota Jakarta...
Alamat BCA KCP Tanah Abang Blok B Telp:0821°8200°233
Telp/Wa 628218200233 Gedung Pasar Tanah Abang Blok B Lantai 5 Kios Nomor 3, 5,...
Alamat BCA KCP Juanda III Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Ir. H. Juanda 3 No.34, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers