Viewing 15 posts - 44,926 through 44,940 (of 49,552 total)
You can't do Raid 10 (striped and mirrored) with only two drives. It requires a minimum of 4. Also Raid 10 doesn't use parity. Raid 5 and a couple of...
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
August 20, 2008 at 9:52 am
Each database needs a log, not each file. You can have multiple data files within one database and only one log file.
What's the output of the following query?
select DB_NAME(dbid), fileid,...
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
August 20, 2008 at 9:22 am
Oh, and log shipping is used to create a warm standby database on a secondary server. It's a high-availability technology, so that if the main server completely fails, there's a...
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
August 20, 2008 at 9:03 am
Each database will have one primary data file (.mdf), zero or more secondary data files (.ndf) and one or more log files (.ldf).
It is not possible to have a database...
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
August 20, 2008 at 9:00 am
If every time the developer runs his code there's a problem, I'd statrt by looking at that developer's code. If there's nothing wring there, run profiler for a while 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
August 20, 2008 at 8:49 am
The permanent solution is to find the source of the indoubt transactions and fix that application to handle its transactions properly.
Are you using Java apps?
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
August 20, 2008 at 8:47 am
I'll be my usual blunt self on this topic.
Using brain dumps is cheating, plain and simple. The same as if you got hold of a test sheet before an exam...
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
August 20, 2008 at 8:43 am
Could you be a bit more specific on what you want?
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
August 20, 2008 at 8:40 am
Make sure you set the max memory for each instance. You do not want multiple instances on a 64 bit server competing for memory. It can lead to interesting issues...
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
August 20, 2008 at 8:37 am
Post the query here if you want advice.
Be careful of the tuning advisor's suggestions. It frequently suggests far more than is necessary.
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
August 20, 2008 at 8:34 am
Sysindexes is only included for backward compatibility, and shouldn't be used in new development.
Besides that, perhaps it will be easier to query the allow_row_locks and allow_page_locks columns in sys.indexes to...
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
August 20, 2008 at 8:31 am
For info on execution plans, there's a great book available from redgate (free when you download an evaluation of any of their tools) on reading execution plans.
Or you can...
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
August 20, 2008 at 1:56 am
Anirban Paul (8/20/2008)
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
August 20, 2008 at 1:45 am
bodhilove (8/19/2008)
Hi Folks,is there any way you can view the sql log (the one under management in SSMS) from the command line?
It's a simple text file and will open in...
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
August 20, 2008 at 1:36 am
I think the problem is those 00000000 values. They aren't convertable to datetime.
Try this
update tablename set newcolumn=CAST(oldcolumn AS DATETIME) WHERE ISDATE(oldcolumn)=1
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
August 20, 2008 at 12:35 am
Viewing 15 posts - 44,926 through 44,940 (of 49,552 total)