Viewing 15 posts - 241 through 255 (of 961 total)
The first screen you see after double clicking the setup file has a link on the left called "installation "
on this page the last link is meant to perform an...
July 8, 2015 at 4:14 am
How did you perform the FO using the wizard in SSMS or the cluster manager ?
Recovery pending is not the same as bringing the databases to sync.
How long did...
July 8, 2015 at 4:10 am
Imagine killing a SPI for an insert statement that was inserting a million rows the time to rollback would be huge. The only time it would be safe to kill...
July 6, 2015 at 12:50 am
OR you could have the EXECUTE AS SYNTAX within the procedure, the main thing is all procedures are not created alike, so each procedures and its execute permission needs to...
July 6, 2015 at 12:33 am
if your trying to stop the default trace you need to use sp_configure > default trace enabled (0)
also the first query doesnt show a trace id 2 so ar you...
July 25, 2013 at 12:24 am
Do u get the same error when using Report manager?
Do u get the error instantly or does the report try to render first?
Does the same issue happen with fewer...
May 7, 2013 at 5:28 am
assuming there is a correaltion between the weeknumber and the date and the days in question are weekdays you can also use datepart and then group by week.
March 26, 2013 at 2:23 am
select log_reuse_wait_desc, name
from sys.databases
If you have the option you can add an additional log file , before that please make sure you go thru the link Gail provided. it will...
March 26, 2013 at 2:20 am
For the most part it looks like the application is the root cause for the issue. try running the below query to identify expensive queries and the then decide if...
March 26, 2013 at 2:15 am
http://msdn.microsoft.com/en-IN/library/ms177413%28v=sql.105%29.aspx
details can be found here
March 26, 2013 at 2:08 am
The question is not very clear of what the end result should look like , it will be better if you provide some data and the expected final output.
Short of...
March 26, 2013 at 2:04 am
the fully qualified version of specifying obejcts is
servername . database name . schema name . object name
by doesnt work do you mean it returns an error or...
January 22, 2013 at 6:03 am
have you configured a listener for the group , thats the way you will connect to the Always on AG
January 22, 2013 at 5:47 am
Please look here for details on how Transactional replcaition works
http://msdn.microsoft.com/en-in/library/ms151706%28v=sql.105%29.aspx
I think you ahv confused it with snapshot replcaition which needs to occur they first time in order to have...
January 21, 2013 at 4:54 am
sqlfriends (1/20/2013)
and when he runs the build script sometimes, it accidently goes to...
January 21, 2013 at 4:43 am
Viewing 15 posts - 241 through 255 (of 961 total)