Viewing 15 posts - 91 through 105 (of 272 total)
What logic is to be used to decide what row from table(s) b, c,d should be joined to a specific row in tablea to end up with a single row...
November 28, 2011 at 12:12 am
Are any of the numeric columns null ? If so the entire expression will return null. Unless they are defined as NOT NULL it would be wise to add coalesce(colname,0)...
November 24, 2011 at 12:11 am
Without more detail that is almost impossible to answer:
a) What is the query?
b) what indexes are there currently?
c) Why do you not want to create indexes?
With some of that informations...
November 4, 2011 at 1:40 am
If you read the requirements around taking these exams you will find that either using braindump material to try and pass them, or copying the questions and making them available...
November 3, 2011 at 2:42 am
Can you elaborate a little? Specifically WHAT are you deploying.
You could be refering to pros/cons of storing images in SQL server or file system, or SSIS packages, or I...
October 25, 2011 at 6:06 am
Compression may help, you need to test it, it will depend very much on the rest of the table definition and how compressible it is. More details on table structure,...
October 13, 2011 at 1:13 am
Can you clarify a couple of things:
a) You say WINDOWS authentication, but are giving a username and password which implies you are ysing SQL Server authentication - which do you...
October 11, 2011 at 3:51 am
Not sure why you think a table alias will simplify things for you, can you explain more?
Some general ideas you may want to consider..
The AS keyword before an alias name...
September 23, 2011 at 1:33 am
As you say there are some interesting differences between versions of BOL. I hope it is just slightly confused wording though, rather than the removing it!
Mike
September 22, 2011 at 6:03 am
No problem Howard.
"The man who makes no mistakes does not usually make anything." ~ Edward Phelps
You had me double checking for a few minutes though. Re-reading BOL it...
September 21, 2011 at 3:34 pm
The "Style" 101 you have used in the convert is US dateformat so your conversion is working as MM/DD/YYYY
You could use style 103 if you want the dates input...
September 21, 2011 at 10:32 am
Best by far is restore from one of your backups.
Do you have any?
Mike
September 19, 2011 at 3:11 am
Couldn't agree more!
I may have missed it but I did not see SAN mentioned at all so was assuming (dangerous!) a simple pair of mirrored local discs.
(Need input)
Mike
August 20, 2011 at 11:11 am
Can you just confirm something, are all 4 drive letters simly paritions on the same mirrored pair of discs?
From what you said in the original post it sounds like you...
August 20, 2011 at 9:18 am
Certainly possible to store multiple versions of the appropriate text in many different languages.
This could all be in one database if required, however the work of translating from say...
August 5, 2011 at 12:20 am
Viewing 15 posts - 91 through 105 (of 272 total)