|
More site info...
SQL Server Administration (2005) | Forum profile
|
|
Forum profile page for SQL Server Administration (2005) on http://www.sqlteam.com.
This report page is the aggregated overview from a single forum: SQL Server Administration (2005), located on the Message Board at http://www.sqlteam.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "SQL Server Administration (2005)" on the Message Board at http://www.sqlteam.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on SQL Server Administration (2005):
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
16
|
137
|
345
|
|
Post:
|
41
|
332
|
805
|
|
|
SQL Server Administration (2005) Posting activity graph:
|
Top authors during last week:
user's latest post:
Connecting to a SQL Server DB...
Published (2009-12-13 23:42:00)
> No, that's a Windows account. You need to create a SQL account inside SQL Server, and then the user will connect via SQL authentication instead of Windows authentication. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
user's latest post:
All Databases corrupt
Published (2009-12-11 23:57:00)
> u there? Regards Paresh Motiwala Boston, USA
user's latest post:
Fragment, reindex
Published (2009-12-13 20:17:00)
> Thanks Tara, I did added to the query and this time I have only SUFFIX as 'IDX' was reported and no 'PK' at the end amongst the results. What exactly happened is we are trying to defragment later want to shrink the MDF and LDF. It got it later the Reindex process did ate again the space(I Knew reindex will generate Transaction Log) but it got the same space before I did the Reindex. As you suggested I should NOT do...
user's latest post:
Log Shipping Problems for a...
Published (2009-12-11 17:25:00)
> If you are designing a simple log shipping scenario (server A to Server B standby) where you do not need to delay the transaction shipping or require the backup files for some other purpose I suggest you consider Database Mirroring which is much simpler to set up and maintain.
user's latest post:
Fragment, reindex
Published (2009-12-13 17:54:00)
> What query did you use to get that? The same index appears to be there several times. -- Gail Shaw SQL Server MVP
user's latest post:
Statistics - downside?
Published (2009-12-11 17:58:00)
> Thanks for the reply. Those options are enabled on the database. I guess I'm confused because SQL Server seems to create its own statistics as needed (_WA_SYS) but if I run the Database Engine Tuning Advisor it recommends I create many more statistics. I guess it can't hurt to create them....
user's latest post:
Connecting to a SQL Server DB...
Published (2009-12-13 19:44:00)
> So I would create a new login and give it the name PC-id\user-id and choose SQL Authenticaion and give the appropiate password?
user's latest post:
backup issue
Published (2009-12-10 17:11:00)
> Hi, I am getting the following error message when I try to backup a db: System.Data.SqlClient.SqlError The backups of full-text catalog '....' is not permitted because is not online. I can backup other dbs on the same server without any problems. Any ideas how to fix this? thank you Aga
|
|
|
|
Latest active threads on SQL Server Administration (2005)::
Started 21 hours, 54 minutes ago (2009-12-14 19:35:00)
by tkizer
>
1. We don't have enough information to be able to answer that. 2. I'm not sure, never seen NULL before for that column. You need to rebuild your indexes more often. You also need to determine if you have missing indexes as that's often a cause of high CPU due to scans. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/...
Started 21 hours, 21 minutes ago (2009-12-14 20:08:00)
by Bustaz Kool
>
A quick review of Books Online will show you that the SQL Server service runs the actual databases (SELECTs, INSERTS, et al) while the SQL Agent service runs the scheduled events (Jobs, Alerts, et al). ======================================= Few things are harder to put up with than the annoyance of a good example. (Mark Twain)
Started 23 hours, 36 minutes ago (2009-12-14 17:53:00)
by tkizer
>
It doesn't sound like it's working at all. Check the SQL Server Error Log to see if you are getting backups. You'll have messages in there if you are. If you are getting backups, then you can view the location of them in the msdb backupmediafamily table. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ ...
Started 2 days, 18 hours ago (2009-12-12 22:50:00)
by tkizer
>
You need to read up on defragmenting (REORGANIZE) and rebuilding (REBUILD) as they do similar but different things. You do not run them both right after each other. Do not shrink after defrag or reindex! In fact never shrink in production unless absolutely necessary for disk space reasons or if you deleted a large amount of data and want to reclaim space. To ...
Started 1 day, 6 hours ago (2009-12-14 10:44:00)
by webfred
>
You can take a backup from that wanted workstation-database and restore it to your server. No, you're never too old to Yak'n'Roll if you're too young to die.
Started 3 days, 18 hours ago (2009-12-11 23:11:00)
by tkizer
>
You probably didn't stop the SQL Server service when you performed the copy. That's the only way to know the files are good. So what state was the service in when you performed the copy? Do you have good SQL backups? Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with ...
Started 4 days, 4 hours ago (2009-12-11 12:58:00)
by rajasekhar857
>
Click on the Particlular database storage option will come go into that.in that full text catalogs option will come.There you can see one name right click on that.Give Delete and take backup.will works fine.There is nothing u can loose by doing so.
Started 1 day, 3 hours ago (2009-12-14 14:01:00)
by Bustaz Kool
>
The SQL Server will, by default, grab as much memory as it can so the "continuous peak" is not surprising. How much memory do you have in the system? For the CPU, what percentage is is showing as a normal and what is the peak? If it consistently is above 65-70%, you are looking at a bottleneck. Also, you can use Task Mamager (Processes Tab) to see which processes...
|
|
Hot threads for last week on SQL Server Administration (2005)::
Started 2 days, 18 hours ago (2009-12-12 22:50:00)
by tkizer
>
You need to read up on defragmenting (REORGANIZE) and rebuilding (REBUILD) as they do similar but different things. You do not run them both right after each other. Do not shrink after defrag or reindex! In fact never shrink in production unless absolutely necessary for disk space reasons or if you deleted a large amount of data and want to reclaim space. To ...
Started 3 days, 18 hours ago (2009-12-11 23:11:00)
by tkizer
>
You probably didn't stop the SQL Server service when you performed the copy. That's the only way to know the files are good. So what state was the service in when you performed the copy? Do you have good SQL backups? Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with ...
Started 1 day, 6 hours ago (2009-12-14 10:44:00)
by webfred
>
You can take a backup from that wanted workstation-database and restore it to your server. No, you're never too old to Yak'n'Roll if you're too young to die.
Started 1 day, 21 hours ago (2009-12-13 19:32:00)
by tkizer
>
I'm not sure what piece of software you are referring to, but if the user isn't in the domain then he/she can connect with SQL authentication instead provided a SQL account has been created for him/her. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that ...
Started 5 days, 3 hours ago (2009-12-10 14:26:00)
by tkizer
>
Use SQLCMD to log into each and run SELECT @@VERSION. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
Started 21 hours, 54 minutes ago (2009-12-14 19:35:00)
by tkizer
>
1. We don't have enough information to be able to answer that. 2. I'm not sure, never seen NULL before for that column. You need to rebuild your indexes more often. You also need to determine if you have missing indexes as that's often a cause of high CPU due to scans. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/...
Started 23 hours, 36 minutes ago (2009-12-14 17:53:00)
by tkizer
>
It doesn't sound like it's working at all. Check the SQL Server Error Log to see if you are getting backups. You'll have messages in there if you are. If you are getting backups, then you can view the location of them in the msdb backupmediafamily table. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ ...
Started 4 days ago (2009-12-11 17:08:00)
by khermann
>
There is only upside to having complete, up-to-date statistics. Stats are a significant factor in how the optimizer generates execution plans, so the more accurate they are the higher the chances of a generating the best execution plan. If you find yourself often having to manually update stats you might consider turning on auto-update statistics for the database if...
Started 4 days, 4 hours ago (2009-12-11 12:58:00)
by rajasekhar857
>
Click on the Particlular database storage option will come go into that.in that full text catalogs option will come.There you can see one name right click on that.Give Delete and take backup.will works fine.There is nothing u can loose by doing so.
Started 4 days ago (2009-12-11 17:08:00)
by tkizer
>
Sysadmins can change the sa password without knowing the old password. Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/ Subscribe to my blog "Let's begin with the premise that everything you've done up until this point is wrong."
|
|
Size: 1,000 bytes
