Viewing 15 posts - 44,941 through 44,955 (of 49,571 total)
DB_Newbie2007 (8/20/2008)
Here is the rest of the post, part of the execution plan:
Any chance you could zip the .showplan file and attach it to your post? It's easier to...
August 20, 2008 at 10:22 am
DB_Newbie2007 (8/20/2008)
Some information:VIEWS are unions of partitioned tables... i.e., VIEW_AllAddresses would be Select * from AllAddresses_Jan08 UNION SELECT * from AllAddresses_Feb08...
First thing that comes to mind... If there's...
August 20, 2008 at 10:21 am
Actually, nothing's running the create proc.
When you get the sql text from sys.dm_exec_sql_text and the connection is running a stored procedure, exec_sql_text returns the create statement, rather than the...
August 20, 2008 at 10:06 am
If you did a database copy, then you should have two databases. What do you use to manage them? Enterprise manager? You should see two entries in there for the...
August 20, 2008 at 9:56 am
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...
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,...
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...
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...
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...
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?
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...
August 20, 2008 at 8:43 am
Could you be a bit more specific on what you want?
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...
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.
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...
August 20, 2008 at 8:31 am
Viewing 15 posts - 44,941 through 44,955 (of 49,571 total)