2003-11-24
cloud computing
RE: DTS output from stored procedure to Excel
I following sp is a modification of one I found here some weeks back. Sorry - can't remeber the origional author. It is used like so.. DECLARE @strReportSQL VARCHAR(8000) SET @strReportSQL = 'INSERT INTO ~XLWS~ ([Column Date], [Column String], [Column Integer]) ' + 'SELECT ' + ' GETDATE(), ' + ' ''Hello'', ' + ' […]
2003-11-21
1 reads
RE: DatabasePermissions vs ObjectPermissions
Gotta love the docs. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-11-19
RE: QOD 17th Nov
quote: Certainly beats the hell out of some of Keith's questions, which I'd love to refute if I could understand them. My questions are easy (if you happen to be one of the 3 people who work in my rather obscure field) Keith Henry DBA/Developer/BI Manager
2003-11-18
1 reads
RE: Where Do I Want To Go Today? - Rich Data Types
Although SQL Server can store, index and search (to a certain degree) complex (non atomic) data types, it offers no native support for them. BLOB's like audio, video are huge, non-atomic data types that consists of parts and subparts and that's non so easy to represent int a relational db. BLOB's are mostly stored outside […]
2003-10-06
RE: Hardware Configuration for SQL server
I would start by reading through microsoft white papers on scailablility. There are several factors above and beyond what you have listed. Number of people connecting to it, concurrent connections, and amount of data per client just to name a few. A database with 10gb of data and 10,000 clients needs something drasticly diffrent than […]
2003-08-12
1 reads
RE: Routine Maintenance
There is a Maintenance Plan wizard you can use in Enterprise Manager. It will guide you as to what type of maintenance you will need. It is not the end of all possible maintenance you might need to do, but it is a good starting point.
2003-08-08
RE: Distributor per publication
Thanks for the quick (and learned) response Mark. It is much appriciated. Mark Rodrigues
2003-08-03
RE: Internal Query Processor Error:
The message is caused when I drop a database and then recreate it (GRD_RESTORE_INFO). It seems to get it nickers in a twist and says cannot find database id 14 which was the previous db id. The new one is 13 but the scripts has a problem finding it.
2003-07-31
RE: How to Break a While ?????
use a bit variable for your break-condition and add it to your while: @do_break = 0 while @counter < @upper_limit and @do_break = 0 begin ... if [your_condition] @do_break = 1 ... end best regards, chris.
2003-07-31
Blogs
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
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