2004-02-14
events
RE: How to convert vertical records to horizontal?
only if you have some unique identifier.select a.productid + b.productid + c.productid from Product a, product b, product c where a.productid = 'A' and b.productid = 'B' and c.productid = 'C'
2004-02-14
1 reads
Suspect databases
How to access and fix suspect database if data and log files are present for that database?--sntiwary
2004-02-14
2 reads
File List ??
Hi AllI'm building a process that reads a directory from the disk and stores the path and files details in a table.Does anyone know of a xp (documented or undocumented) that will list all files in a given directory? I know I can use xp_cmdshell and do a DIR, but I'd prefer not to do […]
2004-02-12
5 reads
RE: Stored Procedure Job Status
I would remove QA from the users and give them an ASP page. From this page they could launch and monitor the process.Less chance of things going haywire because the changed the SQL statement or quiered the wrong table.
2004-02-12
RE: Stored Procedure Job Status
If you really wanted to you can. Just create a table like "sp_Status". In your sp, just insert a record into sp_Status with some description at whatever steps/points you want. But, you would have to ask the user to open another QA window and do a "SELECT * FROM sp_Status" every now and then to […]
2004-02-12
RE: Database Implementation Question
For Security Purposes Access is superior to MSDE 2000. Period!The Fact that the mdf can be grabbed and attached somewhere else makes MSDE usless for YOUR purposes!
2004-02-12
RE: An Introduction to Database Models
Serialization, IMO, defeats the purpose of having a DBMS and brings us back to flat-file land. Part of the definition of a DBMS is that it's shared - many processes can talk to the DBMS at once. Serializing in essence is the same as putting the database into single-user mode and then letting the app hit […]
2004-02-12
RE: Modifying fillfactor without rebuilding the index
"So if I drop and recreate the index in the middle of the operation the users go for a toss."Your create index command will be blocked if the index is being used by user transactions. The user activites will be blocked by recreating index statemnet until indexes are recreated.
2004-02-12
RE: Getting one column from a sp_help_Job
You may create your own version of sp_help_job.Do you want to be notified before going to next step? What do you try to achieve?
2004-02-11
2 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