Be Aware !!!!! (Job Seekers)
Aug 21, 2001
Hi Guys,
This message is posted to alert everyone.
Be Aware !!!!! (Job seekers)
Convey this message to all of your friends.
Nowadays, a new Bad Virus (Trend) is affecting the IT industry throughout United States in the name of interviews.
It is shame for the Company who do this.
Persons are called for interviews and were asked to solve a problem spending like 3 to 4 hours in the name of testing their ability.
(which they really need solution for the problem they are facing in the company)
This guy who attends the interview shows his talents and solve the major problem within a couple of hours (even faster than they expect)
hoping that he will get a job.
As soon as the problem is solved, the person was told that, " Let we think about that, We will inform you later "
But after that there won't be any calls or feedback from the Company.
So some of the Companies utilitize the skills of the people and get their job done without paying which seems to clever.
So Guys Be Aware !!!!!
-Anu
View 1 Replies
ADVERTISEMENT
Aug 22, 2001
Hi Guys,
This message is posted to alert everyone.
Be Aware !!!!! (Job seekers)
Convey this message to all of your friends.
Nowadays, a new Bad Virus (Trend) is affecting the IT industry throughout United States in the name of interviews.
It is shame for the Company who do this.
Persons are called for interviews and were asked to solve a problem spending like 3 to 4 hours in the name of testing their ability.
(which they really need solution for the problem they are facing in the company)
This guy who attends the interview shows his talents and solve the major problem within a couple of hours (even faster than they expect)
hoping that he will get a job.
As soon as the problem is solved, the person was told that, " Let we think about that, We will inform you later "
But after that there won't be any calls or feedback from the Company.
So some of the Companies utilitize the skills of the people and get their job done without paying which seems to clever.
So Guys Be Aware !!!!!
-Anu
View 2 Replies
View Related
Aug 21, 2001
Hi Guys,
This message is posted to alert everyone.
Be Aware !!!!! (Job seekers)
Convey this message to all of your friends.
Nowadays, a new Bad Virus (Trend) is affecting the IT industry throughout United States in the name of interviews.
It is shame for the Company who do this.
Persons are called for interviews and were asked to solve a problem spending like 3 to 4 hours in the name of testing their ability.
(which they really need solution for the problem they are facing in the company)
This guy who attends the interview shows his talents and solve the major problem within a couple of hours (even faster than they expect)
hoping that he will get a job.
As soon as the problem is solved, the person was told that, " Let we think about that, We will inform you later "
But after that there won't be any calls or feedback from the Company.
So some of the Companies utilitize the skills of the people and get their job done without paying which seems to clever.
So Guys Be Aware !!!!!
-Anu
View 1 Replies
View Related
Aug 16, 2007
Hi Folks - Well this is going to be a fun ride. I have a simple table that I need to do some slightly not so simple logic on. I am using SQL2005 and this happens in a stored proc. I need to do this in straight T-SQL and w/o using a cursor, you can use a CTE if needed.
ID
PARENTID
CAT
CATRANK
THEVALUE
1
1
A
0
11
2
1
B
1
22
3
1
C
2
33
4
2
A
0
44
5
2
B
1
55
6
2
C
2
66
7
3
A
0
12
8
3
B
1
13
9
4
A
0
14
10
4
B
1
15
11
4
C
2
16
I need to a variation on select cat, sum(thevalue) from TABLE1 group by cat
which results in
CAT
THEVALUE
A
81
B
105
C
115
the wrinkle is that each item in the group by (A,B,C) needs to consider 1 row from each parentid. in other words if the system is calculating the C row, and a parentid is missing a C entry then the system needs to use the B entry for that parentid.
so to calculate the A row we simply do. this is simple because there is an A row for every parentid
PARENTID
CAT
THEVALUE
1
A
11
2
A
44
3
A
12
4
A
14
SUM
81
the C row is the tricky part. there is no C for parentid 3, so in that case I need to use the next lower ranked item, which is a B
PARENTID
CAT
THEVALUE
1
C
33
2
C
66
3
B
13
4
C
16
SUM
128
so after all is said and done the final result needs to look like this
CAT
THEVALUE
A
81
B
105
C
128
View 3 Replies
View Related
Feb 12, 2004
That targets SQL Server. It deletes all data in random tables, and then truncates the transaction log.
Anyone heard of something like this?
Shaulie
View 3 Replies
View Related
Apr 18, 2007
Hi Folks,
I developed my ssis package against my local database and i would like to test it against remote server database.For that i have modified all of my connection manager settings still i am getting error on oledb destination and Execute T-Sql task.The below is the error.
[OLE DB Destination [11665]] Error: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK__tblPr__532FC765'. Cannot insert duplicate key in object 'dbo.tblPr'.".
Can anyone suggest me what would be the problem and how to resolve this.
Thanks in Advance.
View 3 Replies
View Related
Nov 9, 2007
most articles I read suggest that apps need to retry upon failure in a mirrored environment, using a different connection string, not worrying a whole lot about waiting for the retry. But I heard somewhere that the original connection string can also contain info about the mirrored db, thus eliminating the need to use two different connection strings, and perhaps not even needing to retry programatically. Which is correct? I also heard that programatic retry could be required anyway because of some bug involving the "first" failure and disappearance of a connection pool. Can someone just provide the 50,000 foot view of what it takes to make an app "mirror aware"?
View 1 Replies
View Related
Jul 19, 2007
My goal is be able to compare the total number of rows of a plain file with the total number of rows inserted in a table (with that same file, of course) and then, send an email.
How can I do such thing?
TIA again
View 3 Replies
View Related
Nov 12, 2007
one MS forum MVP seemed to be saying that a connection retry strategy is the key to making an app "cluster aware". Another MVP on sql server forums at sqlteam.com seems to be saying that this isnt how one makes an app cluster aware from a sql perspective, eventhough she seems to agree that a 15 second double retry strategy is a good thing. Am I missing what "cluster aware" really means?
View 1 Replies
View Related
Nov 8, 2007
what proactive steps can we take to make our app (ado, stored procs etc) cluster aware, in the event that we someday use clustering? For instance, I read things about retry strategies etc but dont even know if retry is on a different connection or what appears to be the same connection. We already make our trans as small as possible.
View 7 Replies
View Related
Mar 7, 2006
Hi, all:My VC6 MFC application is recognized as a Unicode application by the drivermanager, so when I read nchar fileds in MS SQL Server database, theSQL_WCHAR does not convert to SQL_CHAR, and the application ASSERT failureat CRecordset::GetDefaultFieldType function.But I don't have "_UNICODE" defined, and have no "W" suffix functionscalled, and my old version program compiled on Feb 2004 just work fine.(source code lost unfortunatally)I read docs like:http://msdn.microsoft.com/library/d...ver_manager.asphttp://msdn.microsoft.com/library/d...ode_drivers.aspbut can't find the right answer.Could any one tell me how dow the driver manager judge the application to beUnicode aware?Best Regards,Qiang He(remove the "nospam." to email me, thanks)
View 1 Replies
View Related
Nov 9, 2007
if an app sits in an environment where both clustering and mirroring are available for HA, are there some simplified best practices, perhaps patterns or .net classes suggested by MS for making the app aware of both clustering and mirroring?
If the mirror db is also contained in the original connection string as a retry partner and SQL failed over automatically, the app wouldnt have a say in first retrying against the cluster. It might prefer cluster first because the mirroring is asynchronous and therefore a bit less up to date than the cluster. This of course assumes the app is ok with the longer failover time. If the partner isnt included, the app needs to be aware of two connection strings.
Is there some feature in SQL for having the best of all worlds, ie one connection string but having a "say" or "rule" in exactly what sql does and doesnt do for you and in what order?
View 1 Replies
View Related
