Forum Replies Created
Viewing 15 posts - 706 through 720 (of 2,463 total)
-
RE: Find out why a maint plan failed
see if you can find something in this table
sysdbmaintplan_hist -
RE: FULL text search
anthony.green (12/12/2012)
yes I saw the execution plan, should upload them as SQLPLAN files as we can then open then in SSMS and naviagte the objects and see the stats, but... -
RE: FULL text search
anthony.green (12/12/2012)
Thats the whole point.%...% will cause a table scan no matter what indexes you have on it
FTS will do the seek and then a match on the FTI
ok...
-
RE: FULL text search
anthony.green (12/12/2012)
but doesnt do a scan which the like does, so full text wins on that one for me.well i think its because there is full text index on...
-
RE: FULL text search
anthony.green (12/12/2012)
What is the output with statistics time switched on and also what do the executions plans show.SQL Server parse and compile time:
CPU time = 16...
-
RE: DB Mail issues with DLL
Saravanan_tvr (12/11/2012)
Yes, I tried to send a test mail from database mail, I am getting the above error, as wellIf use the sysmail_start_sp , I didn't get any output...
-
RE: Problem in Configuring Mirroring
shohelr2003 (12/12/2012)
After configuring mirroring, I opened Mirroring Monitor and I got the following scenarios.@Principal,
@Mirror,
screenshot not visible
-
RE: null value
it seems that you are unaware of NULL keyword , take help from here
http://www.techrepublic.com/blog/datacenter/handling-null-values-in-sql-server-2005/153
PLUS
you query will work like this
select * from table where info is... -
RE: SQL MIrroring
Akkare (12/12/2012)
I recently configured on database in mirroring with automatic failover.I want to push 10 GB of data into primay server and I want to find how much time it... -
RE: Reduce database size
bdeboer (12/12/2012)
When looking at our database it's 226 Gb, but the data is 167 Gb and the logfiles 59 Gb. Does this mean that I can reduce the size of... -
RE: Log backup Fails
Hemant.R (12/12/2012)
hi mahesh,This error occurs when someone has run a process that has broken the log chain. Probably ran the command BACKUP LOG [Jul_Reports] WITH TRUNCATE_ONLY, or the database was...
-
RE: SQL Server index fragmentation is high after rebuilt
sankar276 (12/11/2012)
If the clustered index key long and it is not in increasing order you will find more bookmark lookupsit is not the case, bookmark lookup happens when...
-
RE: what is the use of dbo.dtproperties, can this be deleted?
asir83 (12/10/2012)
Wanted to know if this table can be deleted & will impact any other process?Is it hampering your work ? i dont think aur i will frame...
-
RE: Slow Full backup in SQL SERVER 2008 R2
Aspet Golestanian Namagerdi (12/9/2012)
.It used to take 7-8 hours for the full backup.but now It is running for 21 hours and still it is not completed.How can I check what... -
RE: Performance
tonyarp05 61903 (12/9/2012)
Def, I will go with different Stored procedure for each functionalityPlease let me know if you can give more input.
i will suppport you for this as it...
Viewing 15 posts - 706 through 720 (of 2,463 total)