Viewing 15 posts - 16 through 30 (of 81 total)
Perry is talking about windows account that was granted permissions during the wizard to be a sysadmin for the SQL Server. Looks like you are trying to connect using...
January 29, 2011 at 3:39 pm
Perry Whittle (1/29/2011)
SQL Dude-467553 (1/28/2011)
By default a new install adds local admins as sysadmins in SQL Server
Not in SQL Server 2008 it doesn't!
Vadon, during the installation you would have run...
January 29, 2011 at 12:23 pm
Open a command prompt, and pint the server name do you get a reply? If so does it match the ip address you expect? Try nslookup too as...
January 28, 2011 at 11:37 pm
You will need to collect statistics like what was suggested using some tool. Perfmon is free and works. The only way to determine your bottleneck is to collect...
January 28, 2011 at 11:27 pm
Here is a great blog to learn all about checkdb and corruption, highly recommend reading the site.
January 28, 2011 at 11:14 pm
In addition to Steves list I also watch avg disk read/write sec
January 28, 2011 at 11:09 pm
This is just my opinion...
Of course Enterprise Edition has extra cool features They key is to tie features to your paticular business and show the benefits, if...
January 28, 2011 at 11:03 pm
Is SQL Server the only application installed on the server or is it sharing resources with other applications? Does the performance degrade at the exact same time, or when...
January 28, 2011 at 10:49 pm
A huge difference can be seen in execution plans. Statistics can be created on temp tables helping with cardinality estimates whereas table variables do not so they are assumed...
January 28, 2011 at 10:32 pm
Is your Windows account in the local administrators group, if not you can try adding it in computer management and then connect using Windows authentication. By default a new...
January 28, 2011 at 10:23 pm
One option is to script out your database from your SQL 2008 server and create it on the SQL 2005 server and move the data. You will only be...
January 24, 2011 at 9:35 pm
I've tried to create some filtered statistics on the predicate columns to see if that made a difference since the estimates are way off.. No luck..
Here is a small...
January 21, 2011 at 10:55 am
mister.magoo (1/20/2011)
There are two problems that I see.
1) The table variable with 200 rows is being SCANNED 390,000 times because of the IN.
...
January 20, 2011 at 7:29 pm
Seems like the root problem is that it's doing a LEFT SEMI JOIN without any argument right? Each row is output as a match?
January 20, 2011 at 1:12 pm
Yeah, me too... It seems to work if you right click the file and choose "Save Target As" .
January 20, 2011 at 12:44 pm
Viewing 15 posts - 16 through 30 (of 81 total)