Viewing 15 posts - 541 through 555 (of 1,079 total)
We have to install our database on client machine (end user machine)
Why? If it's a local DB instance on each machine, and each user is in control of the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 9, 2011 at 12:32 am
Try Microsoft's tool, SSMA, I've used it for several migrations without issues.
http://www.microsoft.com/sqlserver/2005/en/us/migration-sybase.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 3, 2011 at 10:09 pm
Thanks for the question...these RAID questions are nice, they let you think a bit 😉
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 3, 2011 at 9:56 pm
Try Microsoft's Migration assistant tool, I've used it for several migrations, you might need to do some manual changes, but overall a great tool..
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 2, 2011 at 11:05 pm
mohammed moinudheen (2/21/2011)
Not in Primary should also be correct.
Got it right, but was a bit confusing, as I agree that there are multiple correct answers.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 21, 2011 at 11:51 pm
connect using the ip or ".", then in a query run SELECT @@SERVERNAME.
is this name the same as your host?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 7, 2011 at 7:26 pm
Make sure all three nodes are configured in Windows Clustering, that all three have potential access to the shared disks, the quorum being essential.
In your setup, you should be able...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 27, 2011 at 11:30 pm
http://msdn.microsoft.com/en-us/library/ms176064.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 27, 2011 at 11:21 pm
Good question...had a related question in the 70-450 exam last month.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 26, 2011 at 12:06 am
Coming to Melbourne (from South Africa) on Sunday for 2.5 weeks...business trip..
Anything you can recommend I do/see while I am there?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 25, 2011 at 11:25 pm
Nice article, thank you Roy.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 20, 2011 at 1:39 am
you must DECLARE variables, and no comma's after each.
try it as:
ALTER PROCEDURE [dbo].[SP_EMP]
DECLARE @STARTDATE DATETIME
DECLARE @ENDDATE DATETIME
DECLARE @STARTDATE2 DATETIME
SET @STARTDATE2=DATEADD(yy, 1, @STARTDATE)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 20, 2011 at 12:26 am
select DATEADD(yy,1,getdate())
this statement will add 1 year to getdate().
yy indicates you are adding years, 1 is the amount of years.
for your SP and script...use this sort of method:
declare @d datetime
set...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 19, 2011 at 11:49 pm
Easy one...but have to admit, made me think a bit..good one, thank you.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 19, 2011 at 11:46 pm
Rather than joining rows, why not build a better table design?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 18, 2011 at 10:23 pm
Viewing 15 posts - 541 through 555 (of 1,079 total)