Viewing 15 posts - 31 through 45 (of 2,007 total)
It looks like you are capturing all values of a list box (selected and unselected). Please pass only selected values from the list. It should be fine with simple IN...
July 9, 2012 at 10:10 am
Let me put this way; I have a table XYZ and an ID (Primary, Clustered Index). I typically don’t query on ID column but it’s used in many queries for...
July 9, 2012 at 9:57 am
As a matter of fact, you can’t avoid the scans (table / index) in real life or practical scenarios but you can minimize those and that’s what Gail is trying...
July 8, 2012 at 2:59 am
I am sorry for the late reply. It came to my notice just now. I am not much regular on SSC these days but I am surprised with a fact...
July 8, 2012 at 2:27 am
I would recommend you to go through Exam Ploicy first. Microsoft will ban the candidate if he/she violates any of the following rules.
Candidate bans
If a candidate violates any testing rule,...
July 8, 2012 at 2:08 am
Jeff Moden (7/5/2012)
guerillaunit (7/5/2012)
July 5, 2012 at 11:27 am
If that's true and you aren't actually violating an NDA or Covenant Not to Compete and your independent development was done neither on compay time nore on compay equipment/software, you...
July 5, 2012 at 11:08 am
I am daring to suggest the Partition Switch (sliding window) here with the assumption that 10 rows that you mentioned are just a fake number and the table has voluminous...
May 24, 2012 at 11:16 am
In this case you should add VacancyID itself as a grain (sounds crazy? I know).
tblIndustry
IndustryID Int Primary Key
Name Varchar(100) (Ex: Accountancy or Sales etc)
(1) IT
(2) Finance
tblRole
RoleID Int Primary Key
Name Varchar(100)...
May 24, 2012 at 11:02 am
Add Data Conversion transformations to convert string columns from non-Unicode (DT_STR) to Unicode (DT_WSTR) strings, or vice versa.
More: http://msdn.microsoft.com/en-US/library/aa337316(v=sql.90).aspx
May 23, 2012 at 11:39 am
In fact, I'd fight against it, kicking, biting & gouging.
+1
We do follow ‘FK_<Child_Table>_<Parent_Table>_<Parent_Column(s)>’. It’s very much self-explanatory with a drawback of its length. We abbreviate the table & column names...
May 23, 2012 at 11:07 am
Whenever there would be any vacancy, it will belong to some industry & some role. It’s safe to have one fact table FactVacancy with RoleID, IndustryID as grain.
And you don’t...
May 23, 2012 at 10:54 am
Are you sure these values are reching to SQL Server as you mentioned?
I don't find any issues on SQL Server side...
declare @vid_url varchar(100), @img_url varchar(100)
select 'http://www.youtube.com/watch?feature=player_embedded&v=5kslTIy-5ro' as vido_url,
'bharatividyapeethsinstofmgmtstudies[highlight=#ffff11]&[/highlight]resea,navimumbai,lib.PNG' as...
May 20, 2012 at 6:39 am
Oops… Just noticed the error message “Boolean Data Type mismatch’. It’s certainly on column ‘Client’ where you entered ‘Yes’. Please enter true/false as valid values for Boolean data type in...
May 20, 2012 at 5:07 am
Try to enter it in ANSI pattern... e.g. 2012-05-20 16:30:23.623
May 20, 2012 at 5:01 am
Viewing 15 posts - 31 through 45 (of 2,007 total)