Viewing 15 posts - 436 through 450 (of 557 total)
bitbucket-25253 (6/10/2013)
This discussion of the subject may be of help to you.
As you can see in the third message in this thread I allready mentioned exactly that link. The referenced...
June 10, 2013 at 11:09 am
Dird (6/10/2013)
Do you mean calculate more accurately the size before actually creating the table?
At the moment I am trying to do the calculation on existing tables. This allows me to...
June 10, 2013 at 10:28 am
Ed Wagner (6/10/2013)
Since the results generated by a stored procedure vary by procedure in both number and type, I don't see how you could create a table to work with...
June 10, 2013 at 9:59 am
PaulB-TheOneAndOnly (6/10/2013)
ben.brugman (6/10/2013)
So how can I calculate the size more accurately?The actual space used by a table is what sp_spaceused reports.
Thanks for your reply, but this does not anwser my...
June 10, 2013 at 8:15 am
sturner (5/29/2013)
I could make the source available, it is written in C# with .net 3.5 runtime (IIRC).
Thanks for the offer, I am not proficient enough with C#.
Problem with the wizard...
May 30, 2013 at 9:37 am
Evgeny (5/29/2013)
You can start from:select * into dbo.newtable
from dbo.oldtable
if you need new table to be populated with old table data, then you can add required constraints and indexes.
I do...
May 29, 2013 at 9:43 am
Lynn Pettis (5/29/2013)
May 29, 2013 at 9:40 am
codebyo (5/28/2013)
Couldn't you do a smart replacing in a text editor to change the part of the index's name the mentions the...
May 29, 2013 at 7:42 am
GilaMonster (5/28/2013)
May 29, 2013 at 7:36 am
Lowell (5/17/2013)
partitioning the data, just by itself, does not mean the queries hitting it will be faster;
I am not concerned that the queries will be hitting it faster.
I am concerned...
May 17, 2013 at 10:46 am
fsuoj (4/29/2013)
His claim is that it is far better to pass SQL statements directly from the code reducing the MS SQL server workload.
I personally think that his claim is bold...
April 29, 2013 at 2:06 pm
Jeff Moden (4/24/2013)
Perhaps you brushed against the following?
Thanks for the link (losing a 'h'):
http://en.wikipedia.org/wiki/Levenstein_distance%5D
This was not what I saw, but 'solves' the same problem. So maybe this is even better...
April 25, 2013 at 2:47 am
wolfkillj (4/18/2013)
The point of a lookup table that serves as the source of a drop-down selection window is to ensure that users enter data in a consistent format and use...
April 22, 2013 at 7:53 am
lptech (4/17/2013)
April 18, 2013 at 5:53 am
Hello all,
Thanks all for your enthousiasm with answering. Thanks.
Where to store the data is not an issue, we have choosen for SQL-server because that is an exelent place to store...
April 16, 2013 at 7:41 pm
Viewing 15 posts - 436 through 450 (of 557 total)