You can also use OUTPUT parameters.

CREATE PROCEDURE proc1

(@param1 INT

,@param2 INT OUTPUT)

AS

SET @param2 = @param1 ;

GO

CREATE PROCEDURE proc2

AS...

In addition to Profiler, if you want to get real time information on queries that are currently in cache, you can get aggregate performance information from sys.dm_exec_query_stats. You can get...

Personally, I create all the databases out of TSQL code and check the code into a source control management system (Visual SourceSafe VSS, Team Foundation Server TFS, there are others)....

I'd change that definition just slightly. It means that the string passed will be unicode. This would be for use with NVARCHAR, NCHAR and the other fields and/or parameters in...

Generally, rather than create statistics, I just create an index. It's a fairly rare circumstance that requires you to manually build and maintain statistics rather than simply have an index....

Wow! That one is busy. Thanks for posting it.

Interestingly enough, it's not returning query text for the blocking process either.

Now that I think about it, maybe it's my test. I'm...

I'm still a bit confused by the question.

By and large, understanding what's occurring at lower levels within the system is useful, but shouldn't be a day-to-day worry. Rather than be...

Because, right now, I'm utterly confused what storing an IP address has to do with "auto locking" which is the title of the post.

Is this 2005?

If so... GOTO? Oooh, yuck. 😉

Using TRY/CATCH you can then do as Gail suggested and fire off RAISERROR which will automatically move you into the CATCH statement. Much...

rajesh_281984 (12/3/2008)

---

Thanks to all of you guys for giving me good information and the code is working fine now. Can u guys suggest some stored procedure samples that i can...

We mostly use schemas for storage requirements or security, but I don't think simple organization would be an issue either. I also agree with Jack, if you have to combine...

It's much easier to answer questions on the forum if you provide a very clear, focused and detailed question. Really general and vague questions can only be answered in general...

Another word of caution for the DTA. I recently ran a series of experiments using the DTA against AdventureWorks2008. It wasn't capturing obvious indexing issues. I don't trust it at...

skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...

One minor detail in addition, run update statistics will full scan.