LutzM

Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 5,502 total)

RE: Trigger help

to add what Lowell already stated:
set @sh_act_*, set @sh_plan_* and set @proposal_* logic queries the related table once per column to be selected. This should be done with a single...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 29, 2011 at 1:11 pm

#1346176
RE: T-SQL Question: Getting different ways to reach from Point A to Point B

May I ask what the purose of this request is?
Different "paths" may lead to different result (e.g. duplicate rows of the target table due to a 1:n relationship somewhere in...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 29, 2011 at 12:36 pm

#1346148
RE: Help with a query / view

I guess you're missing the "aggregated result" you mentioned in your comment.
There's not much more to say unless we have table def and sample data for the tables involved together...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 29, 2011 at 12:21 pm

#1346142
RE: Send an XML from SQL to a specific port!!!

Ok, this is the link where it's been mentioned that the app available on the web has been incorporated into SS2K8:
http://www.sqlskills.com/blogs/bobb/post/A-supported-Service-Broker-external-activator.aspx
The link also include a link to the original 2005...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 28, 2011 at 3:27 pm

#1345549
RE: Help! Migrated from Access to SQL Server 2005 - Can't see newly inserted records

Are you sure your ODBC connection points to the very same database as you're looking at with SSMS? I'd compare the connectiong string and the SSMS database location.

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 28, 2011 at 3:12 pm

#1345537
RE: Optimizing a cursor based routine – Part 1

Great article, Dave! Very well done!

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 28, 2011 at 3:06 pm

#1345531
RE: Send an XML from SQL to a specific port!!!

I can't really give you an example but you might find a solution on the web when searching for "SQL Server 2005 External activation".
I'm not sure if the SQL 2008...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 28, 2011 at 3:04 pm

#1345528
RE: Derived Column

What values do you expect to receive when running a query against that column, let's say now and 6 month from now?
Your computed column definition is based on getdate() so...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 28, 2011 at 1:45 pm

#1345466
RE: Send an XML from SQL to a specific port!!!

Another option would be to fire a ServiceBroker message using the trigger.
This will separate the two processes ad still provide (almost) real time processing.
We've had the once-per-minute-job approach installed for...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 28, 2011 at 1:36 pm

#1345455
RE: using function in query

The code seems to be based on the BOL example A for "CREATE FUNCTION".
In the original code, the function itself is called inside the function.
In your case this would be...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 28, 2011 at 1:24 pm

#1345448
RE: selection getting wrong data because with nolock??

There might be an option to tune your query and or the indexes involved.
Is there any chance you could provide some ready to use table def (including indexes) and sample...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 28, 2011 at 1:03 pm

#1345437
RE: Restrict user from updating n rows at a time

Just to make sure I understand it correctly:
DBADMINS (like you) are not available 24/7, but developers are????
In that case there seems be a lot more to be fixed than the...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 27, 2011 at 9:35 am

#1344597
RE: Restrict user from updating n rows at a time

pujain (6/27/2011)
yes thats correct, we are planning to give access to some database programmer to update production data but still want to be safe (if they forget to put where...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 27, 2011 at 6:19 am

#1344451
RE: Query for Recursive Data Access

Seems like you didn't really found the time to read the article I pointed you at...
The data are still not ready to use.
I'd also question the concept of having all...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 25, 2011 at 4:14 am

#1344065
RE: Query for Recursive Data Access

Please have a look at the first link in my signature on how to provide sample data.
In your Excel file the data types per column are missing as well as...

Lutz
A pessimist is an optimist with experience.
How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

June 25, 2011 at 3:57 am

#1344063

Viewing 15 posts - 1,351 through 1,365 (of 5,502 total)