Hello guys i am developing a emulator for a game and my item table look like this
-- ----------------------------
-- Table structure for `items`
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
`guid` int(11) NOT NULL,
`template` int(11) NOT NULL,
`quan...
Look into the pgcrypto addon. Note that db-level cryptography is tricky. You have key management issues that are not trivial to resolve. In general if you really need this, it is probably worth hiring a professional consultant to do some code review and another one to provide some design revie...
I'll have a stab at that Oracle PCI-DSS question when I get back from work. There really is no need to fork out megabucks for Oracle Transparent Data Encryption. Such a rip-off
Advice:
Normalize data stored.
Consider carefully and figure out your write model. For orders, can you overwrite? do you need to mark superceded and append?
The above are generic data entry pieces of advice, but regarding automated application to application interfaces, you have the issu...
if you've got a window function like count(1) over (order by col1, col2) - does ANSI the ANSI standard say the rows will come out ordered by col1,col2?
"Msg 8180, Level 16, State 1, Line 1 Statement(s) could not be prepared. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Tbl1017.ResourceNTAccount" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Tbl1009.ProjectName" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Tbl1005.ActualWorkBillable" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Tbl1005.TimeByDay" could not be bound."
the sp, staging.LoadHours, is executed once an hour as part of an ssis package. it was working just fine until 10:15 pm last night. From what i can tell nothing in the underlying database structure has changed.
ok, created a table called dbo.deleteme with the same structure as the temp table, set the insert to that instead of the temp table and... exact same thing
Msg 8180, Level 16, State 1, Line 1 Statement(s) could not be prepared. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Tbl1017.ResourceNTAccount" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Tbl1009.ProjectName" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Tbl1005.ActualWorkBillable" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "Tbl1005.TimeByDay" could not be bound.
if i remove either one, or both, fo these, it works: inner join ph.Tasks ta on tt.taskname=ta.taTaskName inner join ph.Employees ei on right(res.ResourceNTAccount,len(res.ResourceNTAccount)-8)=ei.emUserName
BUT, removing the ph.Projects join does not make it work
@JackDouglas didn't see that. prpt1 (where the sp is): Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)
psql2 (where the data is coming from that's failing): Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
I also encountered the same problem where I couldn't add the listener as part of the initial setup and also couldn't add it after either. I was configuring AG's between 2 VM's in the lab and had set up 2 NICs on different subnets on each server. When I disabled the 2nd NICs on each, I was able to...
Can anyone edit it into shape? If not what shall we do with it?
ok, so, i reworked the query a little bit. I turned the dbo.MSP_EpmResource section into a subquery that just selects the ResourceUID and ResourceNTAccount, but also strips off everything so that in my join clause on the ph.Employees table i only have to do res.SerouceNTAccount=ei.EMUserName
@JackDouglas yeah. i've got work orders put in to update all of the servers, but the guy that usually does those is out with a new kid, so it's gonna be a bit. This should hold for now though crosses fingers
See first query below.
Can NOT combine table hint Index and forceseek with two joins and the joins are not on the PK.
How to make the first query compile?
Interesting
- if just one join or the other then can combine index and forceseek hints
- if the index is the PK then can combine 2 joins an...
Look into the pgcrypto addon. Note that db-level cryptography is tricky. You have key management issues that are not trivial to resolve. In general if you really need this, it is probably worth hiring a professional consultant to do some code review and another one to provide some design revie...
Why is 463 in hexadecimal 0x1CF?
What are the values of the letters? Is there a reference to that I can look at to see the values of these letters?
See first query below.
Can NOT combine table hint Index and forceseek with two joins and the joins are not on the PK.
How to make the first query compile?
Interesting
- if just one join or the other then can combine index and forceseek hints
- if the index is the PK then can combine 2 joins an...
