Viewing 15 posts - 45,571 through 45,585 (of 49,571 total)
thegreatsamarth (7/21/2008)
U can do tht by using Cursors, as like:
Cursors = row based processing = slow.
SELECT ROW_NUMBER() OVER( PARTITION BY AccountNum ORDER BY AccountNum ) AS RowNumber,
Ramesh, isn't yours...
July 21, 2008 at 4:36 am
Why do you think idle connections are a problem? All sleeping means is that there's currently nothing running.
July 21, 2008 at 4:28 am
Maybe, maybe not
You need to look at the queries you are running and create indexes to support thos queries. Look at what columns you are regularly filtering on and create...
July 21, 2008 at 4:23 am
Restricting SQL's memory is not going to solve timeouts. It will make them worse. The problem is that you have a lot of data and no (or very few) indexes...
July 21, 2008 at 1:42 am
That's a big topic. Worthy of a book or two.
When use an index - Anytime you want a query to run without having to scan the entire table to find...
July 21, 2008 at 1:37 am
bohra_anand (7/18/2008)
July 21, 2008 at 12:36 am
The roles that the users are assigned to. The object level permissions that the users have (if applicable)
The first you can query from sys.database_role_members and sys.database_principals. The second you can...
July 21, 2008 at 12:31 am
You can read through the error log to get a high-level overview. The details are quite complex. I saw a section in a book I read recently and the description...
July 21, 2008 at 12:29 am
Maybe. Are they all members of 1 or more roles? Do all the users have the same permissions? If not, do you have a table or export file somewhere with...
July 21, 2008 at 12:18 am
ALZDBA (7/18/2008)
And sweet is the odor of victory 😎But sometimes no one acknowleges it ... "after all you just did your job".
The best part was that a few months later...
July 21, 2008 at 12:15 am
Mostly it's if you notice queries running poorly because of out of date statistics. Normally that happens on large tables (million + rows) where the index is on an increasong...
July 21, 2008 at 12:10 am
Yes. Assigne them to the required roles or grant them the permissions that they should have.
July 21, 2008 at 12:08 am
That depends on what your fix user script does.
Oh, for your info. SysUsers ins't a table in SQL 2005. It's a view.
July 21, 2008 at 12:03 am
rinu philip (7/20/2008)
Think this method below would help you : 🙂BACKUP LOG name WITH TRUNCATE_ONLY
USE db
DBCC SHRINKFILE (name_Log, 1)
Be very careful of Backup log with truncate. If you are running...
July 21, 2008 at 12:01 am
It depends what you're looking for. What's your (or your manager's) definition of database health?
I'd start with things like Transactions/sec (to get the throughput), Buffer cache hit ratio and page...
July 20, 2008 at 11:58 pm
Viewing 15 posts - 45,571 through 45,585 (of 49,571 total)