Jacob Wilkins (5/24/2016)

Additionally, the clustering key...

Hi Ryszard,

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...

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...

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...

Hi,

to avoid doing the CU you could try slipstreaming the installation

http://blogs.msdn.com/b/petersad/archive/2010/05/31/rrr.aspx

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...

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...

duplicate response - rubbish internet connection here 😀

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...

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

Perhaps this might help

http://technet.microsoft.com/en-us/library/ms188386.aspx

if it can be near time, could you also not configure a SSIS package to consolidate the data into one location?

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

What drivers...