Viewing 15 posts - 46,951 through 46,965 (of 49,571 total)
It might. It's worth trying, though there are a lot of possible reasons for recompiles.
April 10, 2008 at 6:02 am
laker_42 (4/10/2008)
As Gilamonstor stated, if you are only using 4gb, you don't need to use AWE or the switches. Just set your min & max memory levels for SQL:
That's...
April 10, 2008 at 5:13 am
If you convert the query into a stored proc and change all the front end calls to reference that proc yes it will help.
I would also suggst that you change...
April 10, 2008 at 4:47 am
There's no such thing as a stupid question.... 😀
The order of your statements is fine. The problem is your exists statement
If not exists(select * from IPPxCdr where name = 'Users')
I'm...
April 10, 2008 at 4:43 am
If you only want the day (ie from 2008/04/10 you just want 10) then look at either the datepart function or the day function. Both will do wahat you want.
SELECT...
April 10, 2008 at 4:26 am
Personally I don't see anything harsh in what he said. If the comment had been something like "You idiot, you're posting in the wrong #$%#$@ forum", then it would be...
April 10, 2008 at 4:21 am
Your best bet will be to convert it to a stored proc and cahnge whatever's calling it.
How is that query being called? Front end app? Dynamic SQL?
April 10, 2008 at 4:16 am
Robert (4/10/2008)
Many people work with both ss2k and ss2005, so a forum like this is not necessarily strict ss2005.
There's a SQL 2000 data corruption forum as well here. Posting...
April 10, 2008 at 3:12 am
Should do. Just keep an eye on it for a while, make sure nothing else breaks
April 10, 2008 at 3:04 am
Enterprise manager is one of the management tools for SQL Server. It shouldn't be installed on the server, only on client machines. If you have an installation disk for SQL...
April 10, 2008 at 2:27 am
John (4/9/2008)
1) It appears that all of the DATABASES that I want to work with MUST be in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder.
Only because that's where the SQL engine...
April 10, 2008 at 12:39 am
No need to drop the table or the index
ALTER INDEX <Index name> ON <Table Name> REBUILD
April 10, 2008 at 12:19 am
What does the following query return?
select name, recovery_model_desc, log_reuse_wait_desc
from sys.databases where name = <Name of offending database>
April 10, 2008 at 12:07 am
Could you please have a look in the SQL error log (In object explorer) it'll be under Management ->SQL Server Logs.
Check to see what's there around the time you...
April 9, 2008 at 11:57 pm
karthikeyan (4/8/2008)
yes you are correct,we can seperate it in the DTS itself.But i want to do this with sql query.
Why?
The best way to split apart imported data is as...
April 9, 2008 at 2:26 pm
Viewing 15 posts - 46,951 through 46,965 (of 49,571 total)