Viewing 15 posts - 32,236 through 32,250 (of 49,552 total)
Eugene Elutin (6/24/2010)
Hi Joe, since when are you back to a dusty Texas? Or how you managed to get internet connection in your Borneo hut?
That's uncalled for.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2010 at 4:00 am
digdave7 (6/23/2010)
Msg 1842, Level 16, State 1, Line 1
The...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2010 at 2:04 am
carolwood (6/24/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2010 at 2:00 am
Yes, convert them to real tables or don't use DTA (second option may be best). If it's a small set of queries, ask here. http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
DTA is usually overly enthusiastic about...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2010 at 1:48 am
No. If you need to set precision, use numeric or decimal data type and define an appropriate precision and scale.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2010 at 1:45 am
Suresh B. (6/23/2010)
Table partition (aka Horizontal partition) is quite different concept right?
Yes.
In table partition, data itself is stored on different disks. This feature was introduced in SQL 2005.
Whereas placing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 24, 2010 at 1:43 am
A table scan is a read of all the data pages of a table that does not have a clustered index
A clustered index scan is a read of all the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 3:55 pm
apat (6/23/2010)
Okay, thanks for the reply. I would probably move the log file to some other location if possible.
Good idea. Also see of you can get more space for the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 2:39 pm
apat (6/23/2010)
If I change the recovery model to bulk logged, and then shrink -- will it help?
You're already in simple recovery, in simple recovery bulk operations are minimally logged and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 2:37 pm
Shrink it in small chunks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 2:17 pm
Yup, you're connecting to the default instance. Check the SQLCMD help and fix the settings to connect to the desired named instance. The alter login script is correct.
http://msdn.microsoft.com/en-us/library/ms162773.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 1:13 pm
Hehe
http://icanhascheezburger.com/2010/06/23/funny-pictures-call-911/
http://icanhascheezburger.com/2010/06/22/funny-pictures-no-wayz/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 12:34 pm
Ok, log into SQLCMD and run the following please
SELECT @@Version;
GO
What's the result?
Do note that with the SQLCMD switches you have, you're connecting to the default instance on the machine you're...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 12:29 pm
Maybe try it in two parts. First sqlcmd -E -A -Q to run SQLCMD and log in, then, as a second step, run the alter login statement
alter login [sysdba1]...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 12:12 pm
Steve Jones - Editor (6/23/2010)
You'd want to remove the a file and then startup the server to move it into suspect mode.
That won't send a DB suspect. Maybe recovery pending,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 23, 2010 at 12:10 pm
Viewing 15 posts - 32,236 through 32,250 (of 49,552 total)