Viewing 15 posts - 181 through 195 (of 3,060 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 -...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 14, 2012 at 12:47 pm
labenroth (9/12/2012)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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"...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.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...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 22, 2012 at 11:21 am
Viewing 15 posts - 181 through 195 (of 3,060 total)