More detail. OK.

i have outlook open. im typing an email. to use the @ sign i hold shift+'.

to use the " charachter i hold shift +2 . this is...

this isnt a one time. its been going on for many weeks. and nobody only the sys admins have access to my pc. its either locked or turned off each...

My interview process consisted of 4 interviews:

1. Technical Screening.

This was a confrence call with an existing SQL PFE where I was given questions on all areas of SQL. nothing crazy....

awesome! thanks. I didnt try that as i added two quotes, then tried 3, and thought then that if i kept adding quotes it would make no difference.

Thanks!

aqkhan_k (4/28/2010)

---

Data is copied to the mirrored server in Synchronous fashion to avoid chances of data loss. In order the data to be committed on principal it should first be...

not possible at present unfortunately as there are no UAT envrionments available. Il see about doing a mockup on my work pc..

But im using high protection mode, so i dont have a witness.

So i done all kinds of querying on the data, and couldnt find any duplicate data.

I then emptied all the dimension and fact tables again, repopulated them, redeployed , and...

yea, when i get the quarter, i get the year and the quarter, so quarters are returned as:

2008Q1

2008Q2

2008Q3

2008Q4

2009Q1

etc

awesome. spent ages looking for that! feel stupid now.

im trying to go the opposite way, from an admin/app support role to a db developer role. as i cannot get the experience in my current job, im studying reporting...

hi Folks. to update and close out this thread, i had 4 interviews in total for this.

1. Tech screening - questions of increasing difficulty to gauge my level of...

Thanks folks. This is one of the MS Press training books for 70-432 exam. i have found numerous inaccuracies and mistakes in this book. one more for the list.

we are not having problems. but i have been screaming for some form of a redundancy solution for our main sql servers and we'v been given a nice chunk of...

This doesnt work.

eg. I open one window in ssms, open a tran and do an update.

I open a 2nd window in ssms on the same server and run this:

select txt.*...