Viewing 15 posts - 45,526 through 45,540 (of 49,571 total)
If shrink is currently running, you will just have to wait for it to finish. Adding more files is not going to help if you have an ongoing shrink operation.
July 22, 2008 at 12:37 pm
Ankit Bhurat (7/22/2008)
SELECT * FROM [TableName] where Database = 'ReportDB' and Userid = 'John'...
July 22, 2008 at 12:35 pm
Fix the code's a popular option.
Post the code please, the table structures and the index definitions. Talking about performance in the abstract isn't very useful.
July 22, 2008 at 12:34 pm
As for what queries are run, that will have to be profiler or a server-side trace.
July 22, 2008 at 12:31 pm
CrazyMan (7/22/2008)
how can we do that???
Do what?
July 22, 2008 at 12:11 pm
Can java cache a call to a udf? If so, then you can convert one of those queries into a udf with the two parameters and do a select *...
July 22, 2008 at 12:08 pm
Or, if you prefer (assuming no parameters)
CREATE VIEW IsRowThere AS
SELECT CASE WHEN Row_Count >0 THEN 'True' ELSE 'False' END As ItsThere
FROM
(SELECT COUNT(*) AS row_Count FROM Sometable Where SomeConditions) x
GO
July 22, 2008 at 12:03 pm
Can't java call stored procedures?
July 22, 2008 at 11:59 am
Try killing the data import. Is it blocked by the shrink? If so, the shrink will finish and then the import can continue.
You are going to switch the autoshrink off?
July 22, 2008 at 11:54 am
exec sp_who2
or
select * from sysprocesses
July 22, 2008 at 11:32 am
CrazyMan (7/22/2008)
I found a work around, but iam facing error, the work around is
select * from OpenRowset...
July 22, 2008 at 11:31 am
saurabh.punn (7/22/2008)
HiThis is wht i m got:
Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1
The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.
Please ask your...
July 22, 2008 at 11:11 am
Not possible. A view is a single select statement.
Could you explain a bit more why you're trying to do this?
July 22, 2008 at 10:59 am
What rights does Domain name\DC login have on the machine running SQl server? Is it local admin?
Have a look in the error log (it's just a text file if you...
July 22, 2008 at 10:58 am
No it won't. dbo is not a server-level principal. It's a database-level principal.
Did you ask him about impersonating a sysadmin?
whenever i m trying 2 execute the xp_fileexist proc by mentioning...
July 22, 2008 at 10:55 am
Viewing 15 posts - 45,526 through 45,540 (of 49,571 total)