Viewing 15 posts - 1,786 through 1,800 (of 2,007 total)
elham_azizi_62 (11/8/2011)
I want use a store procedure with input parameters in export\import wizard and save this in ssis for use other time,how to exec procedure in export\import wizard? and then...
November 8, 2011 at 6:37 am
Ninja's_RGR'us (11/8/2011)
@DevRecruiters usually don't troll these forums. You're better off trying to contact them directly.
Also posting your personal info here is just asking for spam.
Have you tried linkedin?
I understand...
November 8, 2011 at 6:23 am
GilaMonster (11/8/2011)
Dev @ +91 973 913 6683 (11/8/2011)
Per my understanding, Compilation just verifies syntaxical errors & object dependencies (permissions & availability etc.)
Syntax and object existence is done by the parser...
November 8, 2011 at 6:14 am
1. Right now it is a theoretical question on wat is the best practice
For a therotical question (with 30K rows), whatever you do is fine. I wouldn't suggest the...
November 8, 2011 at 5:56 am
On the more general point, I wouldn't expect 30,000 rows in inserted and deleted to cause a problem
I agree on it.
Have you captured an 'actual' execution plan for the trigger?...
November 8, 2011 at 5:51 am
Does Instead of trigger with cte or temporary table is beter and in the use an update to the base table
I don't think so. It will add overhead.
November 8, 2011 at 5:47 am
the Question Is : Does SQL Server Uses The Indexes on The Table to compile the query (obve) in the trigger.
No, it does not. Query Compilation has nothing to...
November 8, 2011 at 5:44 am
I normally add my FK's through database diagrams. For example, I create a new db diagram and use the designer to drag the relationships between tables. This...
November 8, 2011 at 1:01 am
For more information review the sytem event log
And what does event log say about this error?
November 8, 2011 at 12:53 am
First, as a good practice you must always have the scripts of jobs with you (secured in some version control utility).
Second, Please provide more information to help you better like...
November 8, 2011 at 12:47 am
forsqlserver (11/7/2011)
The server is only starting using -t 3608 not with -m -cWhy??
Can you please attach error screen shot?
FYI:
m
Indicates to start an instance of SQL Server in single-user mode. Only...
November 8, 2011 at 12:36 am
You might have missed some important steps. Please verify it once.
Installing SQL Server 2008R2 Sample Databases
http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20SQL%20Server%202008R2%20Databases
October 20, 2011 at 9:43 am
I only want to bring back the first instance
This is confusing. How can you guarantee the order of rows in a heap? Which column(s) defines the order of...
October 20, 2011 at 9:27 am
rajiv.varma (10/20/2011)
October 20, 2011 at 9:10 am
That's what Views utilizing UNION are good for
Is it not a CLASSIC implementation in SQL Server (I believe SS2K), when we didn't have partitioning options?
What about maintenance of...
October 20, 2011 at 9:01 am
Viewing 15 posts - 1,786 through 1,800 (of 2,007 total)