Eugene Elutin

Forum Replies Created

Viewing 15 posts - 1,591 through 1,605 (of 2,894 total)

RE: improve performance of sp

...
I humbly submit:
CREATE PROC p_Answer AS RETURN 42;
🙂
It can be few yocto-seconds slower. Can be a great impact if you call it just few septillion times.
Serious performance degradation...
:w00t:
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 6:19 am

#1485637
RE: Triggers

I wouldn't use "Instead Of" trigger for that. The standard one for "after insert,update,delete" will do as fine with much less coding...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 6:13 am

#1485634
RE: Upgrade a procedure

BEGIN and END just determine the logical block of statements.
It's nothing to do with transactions.
Transactions are controlled by:
BEGIN TRANSACTION
COMMIT TRANSACTION
and
ROLLBACK TRANSACTION
statements (or shorter variations of them - all in the...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 4:27 am

#1485580
RE: Table that has all the dates from 2000 till today

Sorry Cadavre, I need to correct the comments for my code.
SELECT CONVERT(VARCHAR, [Date], 112) AS DateSk --Convert the date to string in ISO format. (On any system it will...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 4:17 am

#1485576
RE: Triggers

maheshkrishnas (5/7/2012)
Hi all,
I am new to sql server, How to write a trigger which stops the DML operation on a table for particular time...
Can anyone help on this......
What do...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 4:03 am

#1485567
RE: improve performance of sp

WayneS (5/9/2012)
Tim Walker. (5/9/2012)
riya_dave, I've not been here for a couple of months, but you have at least three of the best experts giving you free help here. You haven't...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 3:48 am

#1485562
RE: SSMS stops while showing query execution plan

i am using table variable ,i know for temp its not gonna work.but i dont have any temp table.
Who told you that for temp tables SSMS show plan is not...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 3:06 am

#1485546
RE: Run Procedure with breaks in between

It's not possible to make stored proc to behave as a multiple threads in client/windows application.
It's possible to stop stored proc execution and continue after some delay as advised in...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 2:57 am

#1485542
RE: Upgrade a procedure

Looks fine to me.
I would error handling and transaction control (if it's not managed by the caller application)...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 10, 2012 at 2:52 am

#1485540
RE: Get related fields from record containing MAX()

... whether it's really impossible to get fields from particular record once SQL Server has located it, just because the path used to locate it was through a grouping clause...
Something...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 9, 2012 at 10:30 am

#1485189
RE: SSMS stops while showing query execution plan

...SSMS just stops working.
what causes it to stop working.
Any idea?
It depends, for example if you are using Amstrad or Sinclair, just buy a newer PC, something with Pentium inside should...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 9, 2012 at 10:24 am

#1485183
RE: case statement in where clause

Shree-903371 (5/9/2012)
I'm sorry I didn't explain it correctly. I need all products and products with status NA must have onhand greater than zero. Below is what i want to display:
ProductStatusOnHand
1230DI20
7689TO20
6758NA10
SELECT...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 9, 2012 at 10:18 am

#1485175
RE: Table that has all the dates from 2000 till today

That will give you exactly what you asked for...
select CONVERT(VARCHAR, [Date], 112) AS DateSk -- ISO
,[Date]
...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 9, 2012 at 10:11 am

#1485170
RE: case statement in where clause

...
I need to show products whose Status is NA and OnHand is greater than 0. ...
You don't need to use CASE WHEN for what you asked. Just:
SELECT * FROM...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 9, 2012 at 10:01 am

#1485158
RE: WildCard Alternatives.

Actually, there are!
You can use other technologies for text searches eg. Lucene for example.
It's very hard to suggest anything particular without knowing your system architecture details, requirements and your...
_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]

May 9, 2012 at 9:57 am

#1485155

Viewing 15 posts - 1,591 through 1,605 (of 2,894 total)