2004-02-26
Tuning
RE: Query Analyer does not work
When I click on the Query Analyzer, nothing happens. I am new to SQL server 7 and would like to move the databases off one drive to another. I wanted to move the user databases from one drive to another using the detach and attach procedures via Query Analyzer. Is there an alternative method ? […]
2003-12-03
RE: Customizing data access
quote: How do you know how to filter the data being returned? ... The time band would specified by the user as part of the query. I have to interpolate/repeat the data within this period/band. quote: Also, why repeat the data like that? Why not just plot the actual data against a standard grid based […]
2003-08-13
RE: Customizing data access
quote: This interval field -- is it able to be of a unit smaller than the smallest time interval stored in the DB? If so, you might be heading for trouble, and should think about adjusting your smallest time interval storage. I, like Andy it seems, am a bit confused as to the overall objective […]
2003-08-12
RE: Using IDENTITY_INSERT with linked servers
I do all my procs thru script files. Compile into dev, test and if all OK compile into uat and live. I still only have one script but different environments. Makes changing and testing easier.
2003-07-29
2 reads
RE: Can't delete a restored database that failed to lo
Someone posted a trick here few days ago by changing the value of category column to 0 in sysdatabases table for the specific database and drop the database. You may try it.
2003-07-28
RE: Sorting
How about: SELECT <rows>, COALESCE(<nullcolumn>, 'ZZZZ') AS <nullcolumn> FROM <table> ORDER BY <nullcolumn> ASC
2003-07-14
RE: How much disk I/O is 'a lot'?
After reading this topic I ran some tests that shows me something different about LIO and PIO's, as shown by 'set statistics IO on'.. If I do a scan on a 40000 block table on a freshly started DB (so nothing cached (in SQL(!)), 'stats' tell me it's doing 1 scan, 40000 logical reads, 0 […]
2003-07-11
2 reads
RE: cursor help
Phew what a mess!! I'll not bother to decipher all that, suffice to say it looks way to bloated for its own good and probably the schema is in a bit of a bad way. But to the cursor... what is it for? You don't use it at all!! All you are doing is executing […]
2003-07-10
RE: Why are there two GENERAL forums?
I suggest a slight name change: General - SQL Server General - Programming Although I do like Andy's option. -SQLBill
2003-07-10
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