|
further reading is available here[^].
|
|
|
|
|
Hmmmm, cheap competitor in town, huh.
|
|
|
|
|
what do you mean?
Is Google expensive and Bing cheap?
If yes send codez to proove it!
I bug
|
|
|
|
|
Troll
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
You guys got it all wrong.
Except maybe for Mycroft Holmes.
He wants codez for inserting the data in the database through the database
No codez needed for that. Just quick fingers
I bug
|
|
|
|
|
Hi,
I'm a freelance developer, I have a database application i developed for a client. I have deployed the database on my client server.
My client uses the builtin\administrator to login into the database server.
My Question is I will like to protect my database from the builtin\administrator from accessing it, because i don't want them to access it from the backend. am a novice to sql server security. Note: its on Sql Server 2000. How do i protect my Database?
|
|
|
|
|
saltcode wrote: client uses the builtin\administrator
Start by changing that (and its password). Give the client his own username, then apply whatever security you choose.
Ideally you'd be using integrated security.
|
|
|
|
|
|
i have a file_no field in my accounting_payment table and i want to run a query to see the frequency of every file, means how many times every file is listed in the table?
|
|
|
|
|
use the count() and group by operators
Select count(*),file_no from accounting_payment group by file_no
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
But I also want to assign the Top number#? For example
Select TOP 5 count(*), file_no from accounting_payment
But to show the TOP (frequency) not the Top (position)
Similarly I want to do it for the amount, for example:
Select TOP 5 max(amount_paid), file_no from accounting_payment
|
|
|
|
|
Do some research in BOL into rownumber() and partition. Using these and a sub select you can get the top N records grouped by yourcriteria and ranked according to your sort requirements.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
May be you can do like this,
SELECT TOP 5 FREQUENCY, FILE_NO
FROM
(SELECT COUNT(*) FREQUENCY, FILE_NO
FROM ACCOUNTING_PAYMENT
GROUP BY FILE_NO) A
ORDER BY FREQUENCY DESC
|
|
|
|
|
I'm doing a bit of searching about these ID's and came across this gem from an Oracle FAQ[^].
If you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be
sure who they really are. With terminals, you can rely on operating system passwords, with
Windows, you cannot.
In the absense of an example, how does one intrepret this. Windows passwords are unreliable? What could someone possibly mean by that?
Chris Meech
I am Canadian. [heard in a local bar]
In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
|
|
|
|
|
The author was a nix nerd and nothing windows based has any validity. I wonder when that was written
I assume the OPS$ id is like the sa in sql server and should not be available to users. Still the statement as such does not make sense.
"If you set REMOTE_OS_AUTHENT=TRUE in your init.ora file, Oracle assumes that the remote OS has authenticated the user."
This seems to imply they do not trust the authentication of the remote OS, surprise, surprise.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: I wonder when that was written
Oracle is still from a world far behind. Even the latest version cannot be installed into C:\Program Files\.
So I guess it was written back in the Windows 3.1 era.
|
|
|
|
|
I'm fetching records from a table as shown below
<b>ID Name PID</b>
1 Ram 10
1 Ram 20
2 Shyam 30
2 Shyam 40
2 Shyam 50
3 Rohit 60
But i want to display records as shown below i. mean to show common name for similar fields
<b>ID Name PID</b>
1 Ram 10
- - 20
2 Shyam 30
- - 40
- - 50
3 Rohit 60
|
|
|
|
|
The relevant word here is display , you are asking the database to do the work of the presentation layer, that is not the database job. Use your presentation layer to do this formating.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
So I am working with some legacy data trying to clean it up and move it into a data mart.
Scenario
5 files of transactions varying from 10k to 10m rows with 100 columns (yeah I know a disgusting number of columns but I'm still working on it)
I load the csv file into a staging table using BCP with all columns as varchar.
Update the dimension tables
Working with the smallest table 13k rows. Using a select statement with joins to the dimension table to get the FK ids I have 10 inner joins so far.
The Issue
To reduce the response time I added TOP 100 to the select statement and was horrified to get a result in 2:26, when I remove the TOP 10 the execution time DROPS to 16 seconds. I always thought top N wold reduce the response time not increase it by orders f magnitude!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I guess it makes a sort of the set before picking the TOP 100.
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
If I had an order by clause I would expect that but there is no order by.
I wonder if SQL 2008 has some implicit ordering (usually the first column in the select statement) that is impacting the query?
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
It depends on the query plan. But you're having some joins so I would assume so.
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
I have around 12 joins and adding more as the day dissapears.
I am not bothered about the query plan at this point as I still designing the procedure. I was just astonished that the TOP 10 increases the response time!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
If you are doing table scans in there, this will have an impact as your code has to read all the rows to determine what the top 100 actually are. The QEP will identify where the problems are.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|