How SSIS and Other Tools Obtain Metadata
How to author stored procedures that use temp tables, so they work with tools such as SSIS and Crystal Reports.
2008-11-03
8,564 reads
Temporary Tables
Demonstration on how to pivot data using temp tables
This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for 🙂
2008-10-10
1,010 reads
One line to drop a (temp) table if it exists
It is very common to want to drop a table, if it exists, before creating it. This script does so, and it works well with temp tables (where the system views are harder to query).
2008-10-06
2,683 reads
Local Temporary Tables and Table Variables
Peter He examines the differences between temporary tables and table variables in SQL Server, showing when you might want to choose one over the other.
2010-01-15 (first published: 2008-09-01)
28,611 reads
SQL Server Table Types
Understanding the types of tables available in SQL Server can greatly enhance your database development experience.
2008-04-02
21,312 reads
Suggestion for R/W and Exec Proc permissions
Need a suggestion for setting up a new Role. It will need to be able to INSERT, DELETE, UPDATE data and EXEC stored procs but should not be able to CREATE / DROP objects, etc.Will granting DBDataReader and DBDataWriter to this role allow users in this role to exec SP's?
2005-05-09
1 reads
RE: Retention
HiI have been a manager/architect for more than 12 years.I feel there are external factors which you should not even bother controlling like pregrancy, child sick so need more money etc..The other factors are guys dont get good work , recognition and most importantly they feel that they are NOT BECOMING MORE VALUABLE by the day. […]
2005-04-29
RE: Database Create Date after restore.
Here's what I've got. I have a stored proc that deletes my old backup files based on the date/time stamp in the filename. I also have a stored proc that PUTs the date/time stamp on the file name in the first place. AND, I have a stored proc which builds RESTORE statements for all the […]
2005-04-06
2005-01-27
RE: Returning Id Column after insert
And in case you need it for your developers in written what Adam said, have a look at BOL for "IDENT_CURRENT". Also contains a nice example about the differences between each approach.
2004-11-06
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers