Viewing 12 posts - 1 through 12 (of 12 total)
Jacob Wilkins (5/24/2016)
stephen.lawrenson (5/24/2016)Hi Ryszard,...A non clustered index, at the leaf level, contains the clustering key (hidden column/s at the end of the defined index)....
A non clustered index, at the leaf level, contains the clustering key (hidden column/s at the end of the defined index).
Additionally, the clustering key...
May 24, 2016 at 3:57 pm
this is where a Select is partly satisfied because the predicates (FROM) are columns within a non clustered index, however some of or all of the columns defined within...
May 24, 2016 at 5:08 am
I got it right - read BOL - to which no answer matched!!! So with flashbacks of Bits and Ints :w00t: from yesterday - I took an educated guess and...
May 8, 2014 at 7:53 am
But the questions states
"tell me the smallest exact number integer data type that can't support a negative number" - which is BIT - it can't support negatives as a -1...
May 6, 2014 at 4:36 am
to avoid doing the CU you could try slipstreaming the installation
April 29, 2014 at 3:41 am
If I understand what you are asking, and this is not an exact answer without seeing your exact requirements
but - yes you could store that information, however you would need...
November 25, 2013 at 10:00 am
With SQL Logins the copy wizard does not migrate the password if I remember correctly, although I think there is a setting to specify what password to set when creating...
November 25, 2013 at 9:39 am
duplicate response - rubbish internet connection here 😀
November 25, 2013 at 9:33 am
Don't use the source wizard and specify your data types? you should be able to get round it with that.
Allow your destination object to create the table once you have...
November 25, 2013 at 9:32 am
Try doing a nslookup <servername> where the servername is the one you are trying to create
Should point you to if it already exists in DNS
November 25, 2013 at 9:27 am
Perhaps this might help
if it can be near time, could you also not configure a SSIS package to consolidate the data into one location?
October 7, 2013 at 7:49 am
The other question is what chasms are your servers/vm nodes on?? are they blades with shared resources
Some things to try and get your storage/infrastructure team to try
HBA queue depth
June 24, 2011 at 3:15 pm