Viewing 15 posts - 42,736 through 42,750 (of 49,566 total)
Just bear in mind that there is a subtle difference in behaviour between the coalesce method and the Varible IS NULL OR Variable = Column method. Specifically when the...
December 1, 2008 at 9:03 am
That's no a serious problem.
As the output from CheckDB said:
Run DBCC UPDATEUSAGE.
No real backups.
Why not?
December 1, 2008 at 8:48 am
If I could send a print screen I would but it is not in any of our servers right noew
It's included in all editions of SQL 2005, from enterprise right...
December 1, 2008 at 8:39 am
torpkev (12/1/2008)
Reorganize data and index pages (change free space per page percentage to 10%)
There's your culprit. Index rebuilds are fully logged and have nasty effects on a tran log.
You can...
December 1, 2008 at 7:25 am
CheckDB, when run without options, just checks for errors.
The best options for checkdb (when run as a regular integrity check) is with the ALL_ERRORMSGS and NO_INFOMSGS options.
If you get corruption,...
December 1, 2008 at 7:16 am
Are you sure your windows login is a member of the sysadmin group?
December 1, 2008 at 7:11 am
Please post in the appropriate forum.
In my opinion, the 'repair minor errors' option should not be checked. Minor corruptions may indicate larger problems in the future. If they get repaired...
December 1, 2008 at 7:10 am
All of the DMVs are present in all editions of SQL 2005.
What error are you getting?
December 1, 2008 at 7:07 am
Ow! Multi-statement table-valued functions are an absolute pain and they tend to perform very badly with larger rowsets.
How many rows do those return?
This update is not necessary. You should be...
December 1, 2008 at 7:04 am
SQL won't release memory by itself. That's by designs and it's expected behaviour. It will only release memory when the OS requests it (in cases of low memory) or when...
December 1, 2008 at 6:56 am
What you can do is just check the size of your log backups. That'll give you an easy way to get the average log volume.
December 1, 2008 at 6:29 am
KPR (12/1/2008)
sorry to reduce it to one sec.
That may not be possible. You're doing a lot of work in there.
What are these?
dbo.fn_ProfileLegalVechile(@ProfCode,@Branch)
dbo.fn_ProfileWareHouse(@ProfCode,@WHCode)
dbo.fn_ProfileCurrency(@ProfCode,@CCYCode)
December 1, 2008 at 6:26 am
KPR (12/1/2008)
Hi Chris, The prev one is the Gilamonster thread I had tried. The below one is yours I had tried.
The suggestions aren't mutually exclusive.
December 1, 2008 at 6:19 am
You could try DBCC SQLPERF(LOGSPACE) for the percentage of the file used. You could also count the rows in fn_dblog(null, null), but that can get intensive and time consuming,...
December 1, 2008 at 5:55 am
KPR (12/1/2008)
Hi Gail,Can you pls give me the syntax for creating index on temp in the proc?
Same syntax as for a regular...
December 1, 2008 at 5:23 am
Viewing 15 posts - 42,736 through 42,750 (of 49,566 total)