Viewing 15 posts - 736 through 750 (of 1,415 total)
Ed Wagner (7/1/2016)
Definitely an interesting question I had to research first, so I learned something new. Thanks very much and have a great (and long) weekend.
Why do you research...
July 1, 2016 at 7:15 am
* we're relational modelers, so we of course know better than to design internal record identifiers directly dependent on any "visible" data... anything published will be readily changeable data hanging...
June 29, 2016 at 2:31 pm
Luis Cazares (6/23/2016)
patrickmcginnis59 10839 (6/23/2016)
Luis Cazares (6/23/2016)
itortu (6/22/2016)
Thank you Luis C.
You're welcome.
Do you understand that this is not the best use of a stored procedure? Stored procedures (as any database...
June 23, 2016 at 3:03 pm
ok maybe the long looking string is actually a backup "device?"
https://msdn.microsoft.com/en-us/library/ms178018.aspx
See if that long string is listed in table sys.backup_devices maybe??? Just tossing out ideas!
June 23, 2016 at 1:18 pm
Luis Cazares (6/23/2016)
itortu (6/22/2016)
Thank you Luis C.
You're welcome.
Do you understand that this is not the best use of a stored procedure? Stored procedures (as any database code) is meant to...
June 23, 2016 at 12:57 pm
do you actually know where the backup files are?
I'm wondering if the server / maintenance plan process had permissions to do the backups, but when you browse them, you are...
June 23, 2016 at 12:49 pm
Jeff Moden (6/18/2016)
patrickmcginnis59 10839 (6/13/2016)
Jeff Moden (6/10/2016)
patrickmcginnis59 10839 (6/10/2016)
RonKyle (6/9/2016)
Besides, if you have to prepare for an interview, then you're not ready for the job.
Disagree. It never hurts to...
June 20, 2016 at 10:47 am
Grant Fritchey (6/15/2016)
The easiest way to start to combine two queries is to...
June 15, 2016 at 11:01 am
Jeff Moden (6/13/2016)
patrickmcginnis59 10839 (6/13/2016)
Jeff Moden (5/25/2016)
krypto69 (5/25/2016)
I have a pretty simple update statement:
UPDATE eligibility
SET primary_plan = 0
FROM temp_eligibility e
WHERE eligibility.eligibility_id = e.eligibility_id
This statement is updating around 7 million rows....
June 14, 2016 at 6:36 am
Jeff Moden (5/25/2016)
krypto69 (5/25/2016)
I have a pretty simple update statement:
UPDATE eligibility
SET primary_plan = 0
FROM temp_eligibility e
WHERE eligibility.eligibility_id = e.eligibility_id
This statement is updating around 7 million rows. Problem is it is...
June 13, 2016 at 2:12 pm
Jeff Moden (6/10/2016)
patrickmcginnis59 10839 (6/10/2016)
RonKyle (6/9/2016)
Besides, if you have to prepare for an interview, then you're not ready for the job.
Disagree. It never hurts to review the basics even...
June 13, 2016 at 6:57 am
RonKyle (6/9/2016)
Besides, if you have to prepare for an interview, then you're not ready for the job.
Disagree. It never hurts to review the basics even though you know them...
June 10, 2016 at 2:30 pm
Sean Lange (6/10/2016)
June 10, 2016 at 1:48 pm
Sean Lange (6/9/2016)
Eric M Russell (6/9/2016)
patrickmcginnis59 10839 (6/9/2016)
Eric M Russell (6/7/2016)
Luis Cazares (6/7/2016)
This is what happens when you trust a forum to answer...
June 9, 2016 at 3:05 pm
Viewing 15 posts - 736 through 750 (of 1,415 total)