Viewing 15 posts - 1,186 through 1,200 (of 1,790 total)
You have to use the overwrite flag if you are using the GUI or the "with replace" option if using t-sql. Make sure that you are chosing a different name...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 18, 2008 at 6:30 am
I think Idera has a tool similar to that in the Admin toolset. Not sure which tool it is but it was similar. MS SQL Health and History also collects...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 2:45 pm
No movies that I know of. Here is an article from msdn - http://msdn.microsoft.com/en-us/library/ms184252(SQL.90).aspx
Read the topic and the sub topics and this will get you started. Post back with more...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 2:38 pm
It relates to Windows server, not file server specifically. Did you see something in that KB article that made it file server specific? Curious.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 1:20 pm
It would be best to google information on RAID levels and database files. You will need to understand your activity type for your databases and then you can pick the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 11:19 am
Sorry for the misinformation. So, are you trying to pass through security information from the connecting user - or just from the web site - to the database?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 10:50 am
From BOL
Logical reads - number of pages read from the data cache
Physical reads - number of pages read from disk
To reduce reads you need to look at a couple of...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 10:47 am
and the link to Andy's article is - http://www.sqlservercentral.com/articles/Miscellaneous/introductiontotheadoconnectionobject/510/
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 10:36 am
I believe it was Andy Warren that walked through this years ago on this site but you can use a neat utility to build and test your connection string right...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 10:35 am
Which processor? If it is the first processor that is because the standard configuration for Windows is for all network traffic (and I believe it considers SAN fabric communication in...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 17, 2008 at 10:21 am
Try using UNION ALL as just UNION will combine results and remove duplicates.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 16, 2008 at 12:13 pm
Nothing should blow up AND you get to take care of those things that are using the SA account inappropriately all in one swift change. :w00t:
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 16, 2008 at 11:50 am
That is exactly what I did and it worked fine. The following code is the brunt of what I used to get this working. Hope it helps. In your case...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 16, 2008 at 11:47 am
Interesting and weird....
Michele - did that work? Very curious.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 16, 2008 at 11:33 am
It should be as simple as changing the setting at the instance level. Make sure that you have Windows Accounts that are in the sysadmin group prior to executing the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
September 16, 2008 at 11:19 am
Viewing 15 posts - 1,186 through 1,200 (of 1,790 total)