Forum Replies Created
Viewing 15 posts - 706 through 720 (of 2,462 total)
-
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...-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-) -
RE: Appropriate range for partitioning
mah_j (12/10/2012)
also i think the page split would be decreased in the partition that i want to select from it.NO , partitoning is not related with page spliting and...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 15 posts - 706 through 720 (of 2,462 total)