2008-08-18 (first published: 2008-06-25)
1,716 reads
Sending scheduled SQL query results via HTML e-mail using SSIS
Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.
2010-09-03 (first published: 2008-04-23)
57,167 reads
2004-10-13
RE: Convert table into a crosstab table in SQL Server
Nivedita: This query does work. Thanks for your help.
2004-07-21
RE: Convert nvarchar column to varchar
Less space used sounds good to me.Can I take it that you ran no other procedure to recover this space?
2004-07-19
RE: SQL SERVER AGENT ERROR
I have been having simular entries in my log as well, they appear randomly. I think this has somthing to do with my FTP site logging to my SQL Server. I have several FTP server logging to a central SQL server as well as my web sites. This is almost like a timeout error on some SQL […]
2004-04-07
RE: Next Number
Yeah - you don't want to use IDENT_CURRENT because of multi-user problems. I would follow the suggestions and use the @@IDENTITY or SCOPE_IDENTITY() in the first stored procedure and pass the value back through an output variable that your VB application can read. This will allow inserting multiple child records which could not be done using […]
2004-01-28
RE: SQL Server on SAN
A SAN is a High Availability storage solution which links physical drives on a storage device to the local machine by either Direct attached HBAs (host bus adapters) or through a Fabric connection via a Fibre Channel switch to the SAN Storage device. You can store you database files on the san with either one […]
2004-01-19
RE: SP Problem With VB6
Have you noticed that when you write an ActiveX DLL, passing values ByRef is faster than ByVal, but when you write an ActiveX EXE the opposite is true?
2004-01-05
1 reads
RE: TempDB operations faster?
SQL doesn't has to recovery tempdb when restarted, so it doesn't need to log everything in the log file as much as in a user db. So write operations should be faster.
2003-12-30
1 reads
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