Viewing 15 posts - 5,326 through 5,340 (of 7,614 total)
It's a security issue. The account that the maintenance plan is running under does not have the relevant authority for that drive, but the account you run under does.
March 3, 2015 at 9:23 am
Luis Cazares (3/3/2015)
Do you mean at the date of the appointment?
SELECT *
FROM TEST
WHERE DOB BETWEEN DATEADD(YYYY, -5, ApptDt2) AND DATEADD(MM, -6, ApptDt2)
Wouldn't you actually need - 6 years + 1...
March 3, 2015 at 9:22 am
I assume you replaced the '...' with your own columns :-).
What specific error are you getting?
March 2, 2015 at 2:32 pm
Yes, you will query back to the original db for the unchanged pages. I confirmed this using BOL as well; from BOL:
"If the page has not yet been updated...
March 2, 2015 at 1:55 pm
You really should leave the columns separate in the other table as well, but here's how to do the join with the combined column:
SELECT ...
FROM table1 t1
INNER JOIN table2 t2...
March 2, 2015 at 1:52 pm
TomThomson (3/2/2015)
ScottPletcher (3/2/2015)
Codd was working for IBM at the time, and IBM asked him to do it. To be fair, a lot of it was not just "ill-conceived". ...
March 2, 2015 at 1:18 pm
DonlSimpson (3/2/2015)
TomThomson (3/1/2015)
siggemannen (2/28/2015)
Hello,I have encountered some weird behaviour. Code that has been working for "eternities" suddenly started to fail.
Alas, i couldn't recreate it on any other machines.
I'm afraid that...
March 2, 2015 at 11:30 am
To keep the optimizer's task straightforward, I would set variables to the desired and end date, patterning the code like this:
--set local variables for start and end date
DECLARE @start_date datetime
DECLARE...
March 2, 2015 at 11:22 am
Btw, trigger coding should concentrate on efficiency, not "step by step" coding, something like below. In this case, the code below is probably easier to follow as well.
ALTER TRIGGER...
March 2, 2015 at 10:58 am
Check the model db. Maybe the db is being dropped and restored, and thus maybe picking up the values from the model db.
I recommend avoiding % growth amounts anyway,...
March 2, 2015 at 10:48 am
As I noted earlier, once you have data loaded you can do:
SELECT *
FROM sys.dm_db_index_physical_stats(DB_ID(),OBJECT_ID('<your_table_name>'),NULL,NULL,'DETAILED')
And SQL will give you the average and max rows lengths for the data you have.
My script...
March 2, 2015 at 9:07 am
Jeff Moden (2/27/2015)
ScottPletcher (2/27/2015)
Jeff Moden (2/27/2015)
February 27, 2015 at 4:47 pm
Jeff Moden (2/27/2015)
February 27, 2015 at 4:21 pm
Jeff Moden (2/27/2015)
ScottPletcher (2/27/2015)
Jeff Moden (2/27/2015)
ScottPletcher (2/27/2015)
Jeff Moden (2/27/2015)
ScottPletcher (2/27/2015)
Your clustered index key(s) doesn't(don't) have to be unique by itself(themselves); SQL will take care of that if it needs to.
......
February 27, 2015 at 4:00 pm
Jeff Moden (2/27/2015)
ScottPletcher (2/27/2015)
Jeff Moden (2/27/2015)
ScottPletcher (2/27/2015)
Your clustered index key(s) doesn't(don't) have to be unique by itself(themselves); SQL will take care of that if it needs to.
... at possibly quite...
February 27, 2015 at 3:50 pm
Viewing 15 posts - 5,326 through 5,340 (of 7,614 total)