I'm inclined to agree that just storing the data I have is the better option than creating data. The values I might have created would be the current value not the change in value. If an item had a value of 5 last month and is still 5 this month I would not get a […]
2003-11-26
What version of SQL are you running and what SP level? I seem to recall something like this with SQL 7 but was SPed with a fix. Have you tried getting another sample as well to test the Index Wizard?
2003-09-04
The queru on the permanent table has to do less actions. Doesn't need to allocate memory, free up memory etc. A good point made before is the size of the memory table. If it is too large why don't you create a Fixed table for it. add an extra field as an identifier or user […]
2003-08-26
1 reads
2003-08-19
Thanks. That works just fine! What I have to do is add a connection via the right click menu, choose an Existing connection and then Cut or Delete the icon. If I add a connection by dragging from the connections toolbar then I cannot delete the unwanted connection. Thanks.
2003-08-19
2 reads
You can't do this from standard T-SQL. The only way is to implement an extended stored procedure that spawns a separate thread. Don't know how to return a result set from this though.
2003-08-18
1 reads
And add the date to that solution to yield SELECT item_no, date, sum(qty) FROM table GROUP BY item_no, date
2003-08-18
I don't think so. Stored procs are stored on the physical mdf files of the database. If you are doing file backups, you are capturing the database schema also because that is stored in the primary file group. Thanks Tom
2003-08-07
If I knew that the user was going after a column that was a Datetime value, using convert would be perfect. But the application will not be able to determine the column data type until the recordset is returned. Thanks for the help though.
2003-08-06
1 reads
Lookup "Counters" in BOL. Under that there is a section called "used by Windows System Monitoring". This explains the different performance counters in SQL Server. HTH Ross
2003-08-05
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers