Viewing 15 posts - 17,836 through 17,850 (of 22,202 total)
Can you post the actual execution plan? Just save it as a .sqlplan file, zip it and attach it.
I see that your TVF is also calling another function. Just so...
March 31, 2009 at 5:46 am
But even then, you can only add users if you have the security admin privileges to do that.
March 31, 2009 at 5:41 am
You don't need error handling or transactions for the SELECT part of the query. There's nothing going on there that requires it.
As to the rest, here's an article I wrote...
March 31, 2009 at 5:13 am
You can't. That's a hard limit built into the system. That's a lot of data to be sorting on. Do you have any options there? What are you trying to...
March 31, 2009 at 5:06 am
If it's eliminating NULL values you might see an increase in performance, but I'm not sure. Can you post the execution plans along with the queries?
March 31, 2009 at 5:04 am
If you're the admin on the server you should be able to connect to it. What specifically is the error message.
If you have security admin privileges on the server, you...
March 31, 2009 at 5:02 am
As the last post showed, @@ServerName gets you the name of the server, DB_NAME() gets you the current database. If you pass it a database ID, it will get any...
March 31, 2009 at 4:59 am
There's nothing all that special about a view. It's just a query that sort of behaves like it was a table. If you need to move data out of the...
March 31, 2009 at 4:53 am
The index is bigger. That means more disk space will be needed to maintain. It's possible that it will have more levels because of the extra size which will add...
March 31, 2009 at 4:48 am
pandeharsh (3/31/2009)
Suppose i write a general proc like this.
Create proc Example
@empid int,
@Mode varchar (1),
@fname varchar (100),
@lname varchar(100)
As
If (@Mode='S'
Begin
Select fname,lname from emp where empid=@empid
End
If (@Mode='I'
Begin
Insert into...
March 31, 2009 at 4:45 am
If the procedures are still in the cache you can query sys.dm_exec_query_stats to see exactly how long the procedure ran, how many resources it used, etc. You can even combine...
March 31, 2009 at 4:37 am
You may need to filter the data. Include a WHERE clause to limit the amount of information you're getting back.
March 31, 2009 at 4:35 am
I guess the question is, do you want grow your own monitors or do you want to go & purchase some of the more sophisticated monitors?
If you want to grow...
March 31, 2009 at 4:33 am
That's all right.
Pick up a copy of SQL Express. It's free and you can learn most of what you need there. When you want to expand into mirroring and...
March 31, 2009 at 4:20 am
iqtedar (3/30/2009)
March 30, 2009 at 6:16 pm
Viewing 15 posts - 17,836 through 17,850 (of 22,202 total)