Viewing 15 posts - 181 through 195 (of 3,061 total)
lonhanner (9/19/2012)
How many concurrent users can you have open at once with sql express 2008 r2.
As far as I know the same limitation on all versions of SQL Server -...
September 19, 2012 at 12:38 pm
aaron.reese (9/19/2012)
if you have 150K columns, how many rows?
Wouldn't be amazing if it is just one row? This would push the limits of the infamous single-table database to something...
September 19, 2012 at 11:39 am
devullapallymanidhar (9/19/2012)
Can any one provide me with good links where we can achieve Data Compression on Sql Databases/tables.DO we have any step by step procedure to achieve data compression.
In my...
September 19, 2012 at 11:31 am
adonetok (9/17/2012)
In ORDER1ORDERID---DATE
111---------2/5/2012
222---------3/8/2012
333---------8/5/2012
In ORDER2
ORDERID---CITY
111----------LONDON
333----------NEW YORK
444----------PARIS
FINAL:
ORDERID---DATE------CITY
111---------2/5/2012--LONDON
222---------3/8/2012
333---------8/5/2012--NEW YORK
444---------------------PARIS
Teacher/Trainer has been talking about "JOIN", isn't it?
September 17, 2012 at 12:44 pm
adonetok (9/17/2012)
Because I do not know which way to join these two tables.
Ask yourself this questions:
1- For each ORDER, do I have one row in ORDER1 and one row in...
September 17, 2012 at 11:24 am
It is not insane, not sure why to include SSIS when storedprocs alone can do the ETL process.
On the other hand, I would refer to the database as a Reporting...
September 14, 2012 at 12:47 pm
labenroth (9/12/2012)
September 14, 2012 at 11:59 am
Nice reseach, congrats! Thank you for providing a working solution, I'm sure people will benefit from it.
September 12, 2012 at 3:14 pm
adminorama (9/11/2012)
I have to populate a table with a pretty large text file and I'm happily using the very good BULK INSERT statement and this "import" procedure is one...
September 11, 2012 at 2:56 pm
davdam8 (9/2/2012)
Definition of BI?Do performancepoint, reporting services, excel services are included on BI?
If you work in the area of BI, what kind of job do you do?
Let me take "definitions"...
September 4, 2012 at 6:58 am
prajwal261187 (8/27/2012)
.. What is data warehousing and oracle database related to?
Firstly... data warehousing is a particular application for databases, in general we divide them in two major categories which are...
August 28, 2012 at 11:19 am
grantbanjo (8/24/2012)
Process by which to append new records or update existing ones and append to associated history table
Described insert/update process can be solved by using MERGE statement. Appending to history...
August 24, 2012 at 4:29 pm
Mohan Kumar VS (3/2/2010)
Our application will be used by 3200 concurrent users in the near future.
I'm in agreement with Rohit. Chances are the base statement for capacity planning...
August 24, 2012 at 5:42 am
mirde (8/22/2012)
There is no requirement to record history, basically a UPSERT/MERGE (upload record if exist, insert if it does not).
is the business aware that the same query looking for something...
August 22, 2012 at 11:24 am
JesseDW (8/22/2012)
Excel Pivot Tables work for views that are not using linked servers pointing to...
August 22, 2012 at 11:21 am
Viewing 15 posts - 181 through 195 (of 3,061 total)