Viewing 15 posts - 61 through 75 (of 629 total)
I agree with David, but I am going to say a Quote a buddy told me once. SQL Server has gotten so big, you can no longer say you...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 12, 2010 at 8:51 am
Sorry didn't reply been out of office, thanks for picking up my slack David :D.
I have never found really a book that has all the answers for performance tuning, I...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 11, 2010 at 1:54 pm
Database Mirroring (as name suggests) is database level, so if you are looking for a way to find out which servers are participating in Database Mirroring sessions; this is not...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 11, 2010 at 11:29 am
I have given each instance/tempdb its own disk. In setting up multi-instance/multi-node SQL Cluster environments, I use disk mount points for one. So each instance gets a mount...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 11, 2010 at 11:15 am
As David suggested that is not possible nor is it proper way to do consolidation. Things you need to evaluate are Processor Usage, Disk I/O, Network Usage, and...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 11, 2010 at 11:08 am
Hi,
Question for you, are you using this query in a stored procedure? If so you might have issue with parameter sniffing; which can cause SQL Server...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
August 11, 2010 at 10:35 am
I use the SQL Scheduler job for my "SQL Automation Engine" I designed. Works pretty slick ;-).
So I would go with scheduler route :D.
- Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
May 21, 2010 at 7:48 am
Assuming the user has permission to execute job with in SQL Server; I think you can simply use sp_start_job.
So make sure the user has SQL Server client tools installed on...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
May 16, 2010 at 5:23 pm
Hi 🙂
I got response from Microsoft, it is for Natural Langauge processing and was used in SQL 7.0 and 2000 but starting 2005 it is not used by SQL Server...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
September 16, 2009 at 8:55 am
Thanks Paul.
What Tal said is also correct, I did actually found a noise.dat file in C:\Windows\System32 that was hidden. In addition to the langauge files; I don't know...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
September 15, 2009 at 4:10 pm
Interesting I have never read anything on that file; how is that file applied in the Index build or search functionality?
My issue turned out to be simple; my automation process...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
September 10, 2009 at 1:27 pm
Further research it appears it excludes other preposition keywords; however it does index many keywords. I found following keywords are also being excluded:
about, after, as, at, before, between, but,...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
September 9, 2009 at 1:33 pm
winan888 (9/4/2009)
Thanks for your info, I got confuse today!.. my app runs very very slow .. my app vendor asks me to shrink database and defrag db..
I am new...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
September 4, 2009 at 5:13 pm
klnsuddu (6/9/2009)
from sql-server-performance article:Cluster Administrator->Resources->SQL Server(InstanceName)->RightClick->click Initiate failover. Here, the SQL server(InstanceName) failed(also SQL Server Agent) and immediately came online and it did not move to node1 when it failed.
What...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
June 9, 2009 at 10:26 pm
There are many more tests you can do; at the end of it you have to be confident that the cluster will stay up. If you are happy with...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
June 8, 2009 at 9:51 pm
Viewing 15 posts - 61 through 75 (of 629 total)