HiIn a new system we are designing, we are considering using parent-child tables to maintain dimension hierarchy data. From these. AS can easily create parent-child dimensions in our MOLAP cubes, but a consultant has said that when processed, no aggregations will be held for the parent-child dimensions.I have tried to find documentation on this but […]
2004-09-07
1 reads
I realize Mahesh's proc is more generic, but it doesn't appear to be working properly. I'm not to interested in debugging it, though, too tell you the truth.He's using the same technique I am, just more generalized. I ran my pivot table script, and it worked just fine. I'd suggest you start with that and […]
2004-08-17
I have a server where there is heavy file fragmentation but it is quite busy and cannot be down for long periods of time. Is there any way other than shutting down SQL Server that would allow me to run a defrag on the datafiles while the the database files are in use?
2004-05-11
It could be that what reddyk needs is the ability to receive a comma-delimited string of arguments and parse out the individual arguments, or something similar. If so, the following code might be enough to get you started (pretend that the whole snippet of code is really a procedure definition, and that @myString is really […]
2004-01-09
1 reads
hi, the SQL 7.0 SP4 version is 7.00.1094 for MS03-031 Paul
2003-07-24
Hi, I think what you may have done is to Restore the database with the 'Leave database read-only and able to restore additional transaction logs' option selected. This mode allows you to restore log file backups so that things like upto point-in-time recoveries are possible. (A traditional backup plan would comprise, for example, a daily […]
2003-07-14
1 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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