Viewing 15 posts - 1,606 through 1,620 (of 3,232 total)
Just a quick note, you can't have a Primary Key constraint on RecordID in your Address table if you plan to allow for a Customer to have multiple Address rows...
August 13, 2008 at 2:15 pm
scott.owen (8/13/2008)
Hey, that was so fast it was scary. I substituted the PK with my values and it seems to work great. Thanks again!-Scott
What else could we expect from The...
August 13, 2008 at 1:56 pm
I think you'll still get that ability with what Lowell's suggesting. Your token transaction history will still be kept in the DownloadOrders table. The view simply queries the...
August 13, 2008 at 1:53 pm
--Restore the headers so you can get the logical file names
--from the original DB. You'll need these later.
RESTORE FILELISTONLY
FROM DISK='Your backup file/path here'
--Use the logical file names from above...
August 13, 2008 at 1:43 pm
Huh, there you have it. I was pretty certain that it would go with the first, but I didn't want to rule out #2. I am surprised, though,...
August 11, 2008 at 9:56 am
Well, think about a federated server model where you've got identical copies, in terms of schema, of databases on multiple physical servers to spread the processing load out over the...
August 11, 2008 at 9:47 am
Mike,
Gail's advice is solid, as usual. I would follow what she's suggested to a T. As far as your SQL Server service account, you should generally run...
August 8, 2008 at 4:18 pm
Well, just think of the case where you have multiple databases on a server. You may want to limit a login's access to which databases they can access. ...
August 8, 2008 at 4:05 pm
It kind of depends on the data. In many instances, the data represents 2 different logical sets of data; hence, you have 2 databases. The reason for using...
August 8, 2008 at 4:01 pm
Again, probably the first one, but the only way to know for sure is to run it and check the plan. The first index seems redundant because it is...
August 8, 2008 at 3:57 pm
Each user must be tied to their own login. Think of it as 2 seperate levels of security passthrough. A user must have a login set up at...
August 8, 2008 at 3:53 pm
1. As we've discussed, at a checkpoint, SQL Server writes all dirty pages to the disk. Dirty pages are pages where data modifications have been made but not committed....
July 18, 2008 at 2:49 pm
kipp (7/10/2008)
yep... below is what i get:(3 row(s) affected)
(3 row(s) affected)
KeyID
--------------------
22222.001.01
(1 row(s) affected)
Kipp, you're still stuck on this? Based on the mock up that I did,...
July 17, 2008 at 4:03 pm
They may produce the same results, but they are different. The first query is checking the variable values for an explicit value while the second query is looking at...
July 16, 2008 at 11:06 am
Viewing 15 posts - 1,606 through 1,620 (of 3,232 total)