| Groups | Blog | Home |
|
March 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Performance ? Posted by Rogers at 4/7/2005 1:39:03 PM If I set the performance monitor alert on the production machine so is there
any performance issue ?...more >>
controller Posted by Rogers at 4/7/2005 11:49:02 AM Can any one let me know about the controller like in the optimization
concern, we need to spearate our log file and data file into different
controller, means sepearate physical hard disk
What the controller is ?...more >>
Help Posted by Rogers at 4/7/2005 6:49:04 AM I just want to discuss one thing with you like we have implemented RAID 5.
In C drive all the softwares are installed and in D there is a storage
device where all database mdf and ldf files stored now the question
is that how can I set my mdf and ldf files into different controller so the
s...more >>
Backup Strategy Posted by Rogers at 4/7/2005 5:35:02 AM what would be the best backup strategy like Full Backup every week,
differential every day and log backup every after 15 mins.
Any guidance ?
...more >>
User Connection Posted by Rogers at 4/6/2005 11:11:04 AM In my production machine there are 800 users connected and servers goes
down... can any one tell me any area where I have to look...more >>
SQL Injection Posted by Rogers at 4/6/2005 10:35:07 AM Can any one let me know like how can we protect the SQL Server against
potential
vulnerabilities such as SQL Injection
Thanks
...more >>
Rebuild Posted by Rogers at 4/6/2005 9:43:04 AM
What would be the best way for every day maintainance like
Should I rebuild all the indexes every day or rebuild the statistics every
day?
Thanks in advance....more >>
For index Posted by Rogers at 4/6/2005 9:11:11 AM Is there any way I can findout all the columns and it's table which used in
stored procedure in the where clause and don't have indexes on it ? If yes
then how can I finout out.
Thanks...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Multi Controller Posted by Rogers at 4/6/2005 6:29:04 AM For large databases backup the databases in to multiple backup devices
spanned across multiple disk controllers.
This will create multiple threads during backup right...
what is the command like let's assume we have three controller C: D: E:
the backup command we can write like
backup d...more >>
Files Posted by Rogers at 4/5/2005 5:55:02 PM Hello Professionals.
We have implemented the RAID 5 so what would be best performance tips for
separating the log and datafiles ? and any other tips for performance would
be highly appreciated.
Thanks...more >>
Index Posted by Rogers at 4/5/2005 8:41:06 AM I have a database in the development and now I want to make sure all the
indexes have been created in all the tables or not.
Can any one let me know how can I found like where I have missed the indexes
...more >>
Web hosting and SQL Server Enterprise Manager? Posted by John at 4/5/2005 12:00:00 AM Do you guys have any idea if web hosting companies usually give access to
SQL Server databases through Enterprise Manager?
I used to have have access to my DB through EE with my previous provider and
now the more I am looking into offers on the net the less I can see this
feature specified.
...more >>
Appricated. Posted by Rogers at 4/4/2005 2:37:01 PM If any one can give me the best recommandation of optimization of my SQL
Server machine wise or database wise or just let me know what are the
parameters I have to follow to make sure my sql server is perfact running on
the production machine or what sort of things I have to consider for
opt...more >>
SQL <-> C++ Posted by PeeS at 4/2/2005 8:17:16 AM Hi,
What technology is the best for communicating VC++ (MFC) application with MS
SQL database ?
There are many ways (MDAC, ODBC, and more), and I don't have spare few
months to learn everything, and then decide what to use.
I need efficient way, easy to distribute, with no extra interfaces in...more >>
Statistics. Posted by Rogers at 4/1/2005 4:15:02 PM Can any one let me know the dept concept of CREATE STATISTICS, what we need
to create and why we need to update.
Thanks
...more >>
Explain Posted by Rogers at 4/1/2005 2:15:01 PM Counter Name: SQL Server General Statistics: User Connections
This shows the number of user connections, not the number of users that
currently are connected to SQL Server. Since the number of users using SQL
Server affects its performance, you may want to keep an eye on this counter.
...more >>
Counters Posted by Rogers at 4/1/2005 1:41:04 PM can any one let me know the name of the most important counters and its
bottleneck values...more >>
With enter. Posted by Rogers at 4/1/2005 10:27:04 AM Get the records with enter like the scanario is...
insert into texttable
values
('Now I am pressing enter
I just pressed')
The output look like when I select the data
Now I am pressing enter I just pressed
but I wannt the data should be look like
Now I am pressing enter
...more >>
Auth. Posted by Rogers at 4/1/2005 6:09:05 AM what if we are making the ASP(Application Service provider) model so we have
to go for windows authentication or standard authentication?...more >>
Backup settings for server registrations in SQL Server Enterprise Posted by Gabriel Martin at 4/1/2005 12:29:01 AM Dear SQL-Server-Gurus
I have version 8.0 of the SQL Server Enterprise Manager with many server
registrations organized in groups. I would like to backup these settings to
use them on an other computer or to have a copy in case I have to reinstall
my computer.
Is there any way to create a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |