Viewing 15 posts - 3,286 through 3,300 (of 3,406 total)
Actually, a point in time restore is probably the best option... I was thinking that the damage had not already been done - but if it has, that's your best...
June 2, 2013 at 9:41 pm
Yes, you could, but that's like killing a mosquito with a bazooka. Wrapping the statements in question in a transaction would be much less overhead and work.
June 2, 2013 at 4:16 pm
probably sp_sendDBMail and jobs. Definitely not triggers.
May 14, 2013 at 10:55 am
not much to go on...
what kind of message? Based on what? Service Broker might be a solution.
May 12, 2013 at 1:37 pm
I'm a recovering Access developer, so my opinions may help you (and may well not).
Anyway, Access is good for prototyping and front ends (if you cannot use ASP.NET or VB.NET...
May 7, 2013 at 5:10 pm
This design:
CREATE TABLE #TestTb1 ([Sample_ID] VARCHAR(10), [P1] INT, [P2] INT, [P3] INT, [P4] INT)
is going to bite you. I would strongly recommend not doing that. (I worked on...
May 4, 2013 at 9:40 pm
Wrong design.
CREATE TABLE Test(
PatientID int,
TestID int,
Reading decimal(10,4)
TestDate DateTime
);
Then the rest is trivial.
May 4, 2013 at 5:53 pm
Big topic. You might want to start by looking up partitioning. Do you need to keep some of the records in the table "active"/editable while others are not?...
May 4, 2013 at 5:33 pm
You could also do this in Reporting Services with a Matrix...
April 30, 2013 at 11:10 pm
did you back up and restore MSDB from your old server to the new one? that's where the jobs are stored.
April 24, 2013 at 10:54 pm
Why not split the two types out inside SSIS:
select someData, ISNUMERIC(someData) As NumTest
from test
WHERE ISNUMERIC(someData)=1;
The example is kind of overdone, but the idea is that you can test/filter for whether...
April 24, 2013 at 10:50 pm
It's because they know how to use the Force, and we don't...
Silly Us!
April 9, 2013 at 6:06 pm
Might do that... they have Access and VBA is easy... forgot about doing pass-through queries... Makes a nice front end, but not my favorite as a backend.
March 26, 2013 at 9:24 am
As I understand it (doesn't mean it's right), each salesperson is assigned to one or more geographic areas, and the customers are inside them, so it should be hierarchical. ...
March 25, 2013 at 4:34 pm
That's what I thought... I have no idea how else to do this besides RLS. (Thanks for the warning of how much fun it is... at least now I...
March 25, 2013 at 3:28 pm
Viewing 15 posts - 3,286 through 3,300 (of 3,406 total)