I'm trying to work with Dimension Security for multiple dimension, but i have som problems that maybe someone can help with.In my exmaple belove i have 2 dimensions. The security should work as, if a user chose UK, he has only allowed to se all things for UK (The X's), but if he chose to […]
2004-11-05
1 reads
2004-10-06
Re-indexing all the tables on all the databases might be an overkill. You might want to re-index tables which are highly fragmented. I had a script for that somewhere and will try to find it and post it.
2004-08-18
A mapped drive is only available to the user who creates it. SQL Server runs under the system account and the mapping is not recognised by the system account(unless it is a share). UNC means the fully qualified path i.e. \\servername\drive_letter$\directory Can you try the below sqlmaint -D Database -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "\\servername\I$\DIRECTORY" […]
2004-06-30
What is the actual command you are using?Are you telling it to put it on e: or e:\ ?-SQLBill
2004-04-30
Are you looking to total some value(Sales) by year? You may want to consider using something like:Select Total(Sales) Group By Year(SalesDate)For example: SELECT PaidDate, sum(AmountPaid) FROM Payments Group By PaidDate order by PaidDateThen take that result and Insert it into a table. I prefer to calculate these things and keep them dynamic rather that creating […]
2004-03-15
http://support.microsoft.com/default.aspx?scid=kb;en-us;269587&Product=sql2k
2004-02-11
I've had problems where page breaks were inserted, screwing up the code. I have no idea if this is your problem, but it's something to look for.
2003-09-15
Have a look at Frank's reference at http://qa.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15691&FORUM_ID=9&CAT_ID=1&Topic_Title=ntext+confusion&Forum_Title=General
2003-08-28
1 reads
malb - you sound like a seasoned pro that has dug thru the dungeons of microsoft hell and arrived, triumphantly, at the gates of the dark lord himself and shouted: "I will not go quitely!".... anyhew....one more thing i forgot to mention and it is all-important in this day-and-age of budget slashing - if you […]
2003-08-20
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