Viewing 15 posts - 256 through 270 (of 455 total)
what happens if you just run this code?
see attachment....
January 5, 2011 at 11:32 am
This is great info. Thanks Wayne.
what do you think about making ALL x.data.values to be VARCHAR in the event that the XML is not well formatted?
January 3, 2011 at 1:46 pm
First you need to share what your entire test system looks like.
Does your SSD support TRIM?
Are you running 2008 R2?
Windows Server 2008 R2 support the TRIM function, which the...
December 27, 2010 at 6:40 am
under what service account does the Agent try to start?
December 22, 2010 at 7:57 am
sounds like Oracle speak to me...
in SQL a database is what Oracle calls schema.
in SQL an instance is what Oracle calls a database.
so, to answer your question, each app should...
December 22, 2010 at 6:38 am
backup / restore is nice and easy.
syncing logins will be an issue. you will not be able to script out logins from 2000 and script them in to a SQL...
December 22, 2010 at 5:49 am
Lowell (12/21/2010)
Geoff A (12/21/2010)
December 21, 2010 at 1:21 pm
The ability to shutdown and restart a service is a permission at the server level. By default, Domain Admins are members of the local Administrators group on a server. The...
December 21, 2010 at 1:12 pm
the ability to control SQL services via SSMS has nothing to do with SQL permissions.
it is based on windows level permissions. local security and domain security policies.
users in the Administrators...
December 21, 2010 at 12:47 pm
RAID 10 is fastest and safest for database.
December 21, 2010 at 12:37 pm
a NetworkService account will not be able to access SQL from IIS.
you will need to use a domain account for that unless you create a DSN entry on your IIS...
December 21, 2010 at 12:29 pm
is the delete statement within the cursor the same as the standard delete statement?
the cursor might be hitting a good index within its statement.
what are your SQL statement?
December 21, 2010 at 12:26 pm
depends on how many inserts we are talking about i guess.
replication would be my last option. I would do one of two things;
as you said, use a trigger. or just...
December 20, 2010 at 12:26 pm
yes, there is a very minor hit, but consider the alternative. everything comes at a cost. would you rather have unknown deadlocks or (IMHO) a barely measurable hit in performance?
December 16, 2010 at 2:33 pm
Viewing 15 posts - 256 through 270 (of 455 total)