LutzM

Forum Replies Created

Viewing 15 posts - 286 through 300 (of 5,502 total)

RE: Restriction on Primary key

sqlvogel (12/4/2013)
...
A primary key constraint is a uniqueness constraint. Would adding a third key as you suggest really make any difference to the question of which ought to be "primary"?...

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]

December 4, 2013 at 11:43 am

#1670817
RE: Restriction on Primary key

Why would someone need a primary key for husband and wife?
None of the two makes a good primary key, but both should have a unique constraint - if such a...

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]

December 4, 2013 at 11:00 am

#1670800
RE: How to convert a CSV file into XML?

The query seems to be correct.
But the problem description as well as the answer is there, too:
One solution is to increase the number of characters retrieved from the server 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]

December 2, 2013 at 4:48 pm

#1670242
RE: Enter user-defined variables at runtime

I don't recommend to rely on a phone call to create the snapshot.
Usually, working hours of Dev and Prod are not identical. It won't be too long until the Dev...

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]

December 2, 2013 at 12:25 pm

#1670202
RE: Restriction on Primary key

Lowell (12/2/2013)
...in SQL server, the PK is used to define how the data is physically stored on disk.
Objection, your Honor!
The physical storage on disk is based on the clustered index,...

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]

December 2, 2013 at 12:16 pm

#1670199
RE: Restriction on Primary key

A Primary Key is used to identify a single row based on the "business rules". This key is used in foreign key references to ensure logical consistency of the business...

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]

December 2, 2013 at 12:13 pm

#1670194
RE: Enter user-defined variables at runtime

One option would be to run the code as a different user with elevated permissions using the EXECUTE AS clause.
But this would require to replace the dynamic SQL with hard...

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]

December 2, 2013 at 9:51 am

#1670157
RE: Query performance

Like Jeff already suggested: it might be required to recompile the code since the cached query plans might still not reflect the new index.
Jeff suggested the DBCC FREEPROCCACHE followed by...

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]

December 2, 2013 at 3:12 am

#1670044
RE: updating rows with xml

Would it be an option for you to create a view with the xml formatted result set (instead of storing it "physically")?
Might help to deal with the data in a...

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]

December 2, 2013 at 3:01 am

#1670039
RE: Unlocking stored procedures

Check with the database owner if the permission to modify those stored procedures can be granted.

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]

November 29, 2013 at 11:57 am

#1669866
RE: SQL Database Mail Failure

What exactly is your question?
Based on the error message the named SQL Server instance W6010_01 at the server W6000 was not accessible.
There are numerous possible reasons for that message. You...

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]

November 29, 2013 at 11:54 am

#1669865
RE: deleting some data from a column

from my point of view the first step would be to figure out how it happened and to close that "back door". Otherwise you might get faced with the very...

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]

November 27, 2013 at 2:41 pm

#1669587
RE: How to copy data from multiple queries to same excel destination in ssis

I'm not sure what your template looks like...
Do you want to have each table loaded to a separate Workbook?
If so, you could have a look at this link how to...

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]

November 27, 2013 at 2:30 pm

#1669586
RE: Avoiding Large Number of db Columns in SQL Server - Database Redesign

I'd go with a separate table with the columns ObjectiveId (as a foreign key reference to the current table), OutcomeId, KSA_aspectNo, KSA_AspectValue together with a column referencing the related.
I'm not...

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]

November 27, 2013 at 2:14 pm

#1669584
RE: Execute an sp for rows returned from a query

I guess the big question is:
What kind of validation is performed?
Would it be possible to store the "bunch of rows" to a temp table with an additional column to mark...

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]

November 27, 2013 at 1:40 pm

#1669578

Viewing 15 posts - 286 through 300 (of 5,502 total)