query plan cache control ? - 2 queries show same number of reads ?
Mon, 6 Oct 2008 13:35:41 +0100
SQL 2005
I have a table with 100m records with a DATE column.
Within this table I have1 weeks worth of data from a single object.
I query by date range to return the last hour for this single object.
SQL Profiler shows me the query takes 75 secs and shows15000 reads.
I query again using the same parameters but ...
|
Re: Problem With
Mon, 6 Oct 2008 07:15:53 -0500
"mahmoudmga" <mahmoudmga@gmail.com> wrote in message
news:d55a70f7-c753-449a-9117-00a645d617c4@t41g2000hsc.googlegroups.com...
> Hi.
> I have a lan with win2003 Server/AD/DNS.
> i define domain users in its machines as POWER USER , but in some
> clients (With WinXP Proff) we install SQL Server 2000 and to runn ...
|
Disk space usage report
Mon, 6 Oct 2008 12:34:58 +0530
Hello,
SQL 2005
My manager needs a Reporting Service report with these parameters:
- total size of database on disk
- size for each data file
- empty space in each data file
- comparison to last month
- total growth for the period (based on months)
I checked out the existing 'Standard reports' in SSM ...
|
To restart SQL Agent service
Mon, 6 Oct 2008 12:16:28 +0530
Hello,
I am new to SQL Server clustering.
I have a SQLServer2005 active-passive cluster and both SQL service and SQL
Agent service are cluster resources. What is the correct way to restart SQL
Agent service?
- Using SQL Configuration Manager and restart SQL Agent service
- Using Cluster Admin, right cl ...
|
DB-Library Network communication layer not loaded.
Mon, 06 Oct 2008 05:55:56 GMT
Hi,
We are getting the below error in one of our application server while using
"ISQL" command.
DB-Library; DB-Library network communication layer not loaded.
below is the isql command that we were using
isql -S <Server IP Address> -d <Database Name> -U <username> -P <password> -
i <filename.sql>
...
|
sql server 2000 to server 2005 migration
Sun, 5 Oct 2008 20:27:00 -0700
i have been working on sqll server 2000.now i purchased a new laptop wherin i
got windows vista with sql server 2005 preinstalled.i find it very
uncomfortable to work on it.please is there a work out to install sql server
2000 on windows viata home edition thanku... ...
|
SQLServer 2008 : Maintenance plan
Mon, 6 Oct 2008 00:13:04 +0200
Hi everyone,
I send this post regarding a SQLServer 2008 problem.
I'm using two databases and i've decided to backup them periodically. I've
made a maintenance plan, choosed my dababases, choosed a full backup
and checked "Backup set will expire after 2 days". I've choosed "create a
backup file for every ...
|
|
|
Application won't connect after failover
Sun, 5 Oct 2008 05:20:00 -0700
We've setup mirroring in SQL Server 2005 SP1 and it works fine on the
database side. The problem is the application that connects to the database
won't connect to the new principal db after failover. The application uses
the SQL Native Client Driver ODBC connection. We've entered the mirror
information in th ...
|
Error 17803 Severity 20 State 4 Insufficient Memory
Sat, 4 Oct 2008 20:49:00 -0700
Recently I'm facing an SQL issue whereby the SQL always gives the error
"Insufficient Memory". Based on the Event log, it shows Event ID: 17052
"Error 17803 Severity 20 State 4", source: MSSQL.
I have tried few things but still couldn't solve the problem:
- add this line to boot.ini
"multi(0)disk(0)rdisk(0 ...
|
Bulk insert and Keepnulls
Sat, 4 Oct 2008 07:27:00 -0700
Keepnulls does not seem to work with date field in bulk insert in SQL 2008.
Is there a trick to it?
My command is:
EXEC( 'BULK INSERT #mstrUpdate from ''' + @fileName + ''' WITH
(FORMATFILE=''mstr.fmt.xml'', ROWS_PER_BATCH = 10000, KEEPNULLS)' )
my input file is fixed length.
Thanks ...
|
