Viewing 15 posts - 181 through 195 (of 7,164 total)
Comments are most useful when they comminicate intent as opposed to structure. No need to rewrite Chapter 1 of every "how to write T-SQL" book alongside your code. However, you[\i]...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 21, 2016 at 1:10 pm
etl2016 (2/21/2016)
I am willing to go for a All-in-One Desktop, for home computing/educational purpose, mostly having Microsoft development apps such as below.
Could you please suggest if 8GB RAM and Core...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 21, 2016 at 12:17 pm
kshah82 (2/21/2016)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 21, 2016 at 7:48 am
kshah82 (2/20/2016)
Thanks for the response!Sorry my bad, Badge ID is he Employee ID.
Take these two rows:
INSERT dbo.Source2(EmployeeID, ClerkID) Values(123456, 'abcd');
INSERT dbo.Target2(EmployeeID, AssetValue) VALUES(123456, 'abcd');
yes, no update
OK, got it.
INSERT...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 20, 2016 at 10:04 pm
assefamisganaw (2/20/2016)
Now I want to execute query from Server1 and write to Server2.
I have two physically separated machine installed with the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 20, 2016 at 12:37 pm
TomThomson (2/20/2016)
Ed Wagner (2/19/2016)
TomThomson (2/19/2016)
ZZartin (2/19/2016)
Driverroad hog
Harley
Davidson
Curry
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 20, 2016 at 11:15 am
JRoughgarden (2/19/2016)
R Barry Young's procedure fails if any databases have conflicting collations. Report Server databases have Latin1_General_CI_AS_KS_WS collations, whereas the default collation is often SQL_Latin1_General_CP1_CI_AS.
OK, so can you post the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 20, 2016 at 8:30 am
ramana3327 (2/19/2016)
I am working on creating alert for db status when there is any change except online for all databases
I tested using if @state = 'Online' but it didn't give...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 20, 2016 at 8:16 am
kshah82 (2/20/2016)
if the Badge IDs and Asset Value and Clerk IDs match then no action.
if the Badge IDs match and Asset Value...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 20, 2016 at 8:11 am
As I understand it, this code is never even executed so your TRY/CATCH is not even considered. During the early stages of execution the QO is evaluating the possibility of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 20, 2016 at 7:56 am
Phil Parkin (2/19/2016)
I think that you can do it using catalog.set_execution_property_override_value.
Good call. You can.
I remember now..I explicitly went towards promoting everything we used to set on the dtexec command line...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 19, 2016 at 2:51 pm
After posting this new thread I went in and the Topic Options are in fact "No Email Notification (Just Add To List)". Did I accidentally change a default option somewhere?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 19, 2016 at 6:42 am
It's been over a year since I looked into this but during a migration from 2008 R2 Package Deployment model to 2012 Project Deployment model I seem to remember having...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 18, 2016 at 9:31 pm
Jeff Moden (2/18/2016)
Gstar1224 (2/18/2016)
...calculate the number of concurrent users every hour...
What does that actually mean? Do you mean, for example, if someone were logged in from 1:30AM until...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 18, 2016 at 9:05 pm
WITH cte AS (SELECT DOCTOR, PATIENT, [DATE OF VISIT], [TIME OF VISIT],
LEAD(PATIENT, 1,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 18, 2016 at 7:10 pm
Viewing 15 posts - 181 through 195 (of 7,164 total)