RE: BACKUPS FAIL
Sounds like the backup routine can't read pages form the DB. Like Allen said, I'd check your disks first. Run a consistency check or a CHKDSK. Also, run a DBCC CHECKDB to make sure you don't have any corruptions.
2003-08-06
Metadata
RE: Table recreation via script
Try SQL Scripter to script your data in T-SQL. Very cool tool ! You should try it. It's free. Regards
2003-07-30
RE: Storing arrays in SQL.
Hi Martin, quote: I've been set the task of converting an app that uses DOS B-Tree style databases to SQL. One thing I'm finding is that the existing databases make heavy use of arrays. i.e. 12 individual records of a customers monthly spend are not stored in 12 seperate fields but are just blatted into […]
2003-07-29
1 reads
RE: Storing arrays in SQL.
Stop. Desist. No! please, please don't. I've seen too many similar designs (including those by me) that have been created with the same good intentions. It just doesn't work well within a relational DBMS. Cheers, - Mark
2003-07-29
1 reads
RE: Storing arrays in SQL.
Thanks for that. I was mulling over the idea of including a text field into the record that contains the data in a comma delimited format. My class can then stream the data in and out, and cope with variable lengths of arrays. I'm hoping (because I'm no expert), that this will have less of […]
2003-07-29
1 reads
RE: Storing arrays in SQL.
Martin, There's no array type structure in SQL. It sort of violates relational concepts. If I were you I'd resign myself to to the slightly more difficult task of creating child tables for the repeating data. However, in the long run you'll find you'll be able to process that data (updating or querying) quite easily. […]
2003-07-29
2 reads
RE: Displaying Execution Plans
Hi Randy So whats the combo of commands to "get a text based execution plan after the execution of the statement", as showplan_all and showplan_text dont physical execute the parsed statement but return the text output. Just missing in the article. Nice summary btw, beats hunting around the docs. May be worth detailing the output […]
2003-07-27
1 reads
RE: Bad practices
quote: I'm assuming blind panic took over for awhile Don't ask! quote: How did you correct it? Newinstallation, restore. quote: *I didn't do anything it just got complicated* Is this your own, or is it taken from somewhere else? Here's another one fot the NOT to do list. - first thing after installation on target […]
2003-07-21
RE: comparing specific rows
could I not implement some kind of loop construct..heres what I have..its quite self explanatory.... delete t1 from unique_cust t1 INNER JOIN unique_cust t2 on t1.dup_code = t2.dup_code and t1.rec_lda < t2.rec_lda and t1.dup_code <> 0 and t2.dup_code <> 0 Declare @cust_iddelete varchar(255) Declare @cust_idkeep varchar(255) Declare @id int /*Set @id = ?*/ select @cust_idkeep […]
2003-07-18
1 reads
RE: Enabling Security Option
How are you logged in during this scenario. What's the result when you run: select suser_sname()
2003-07-11
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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