can i have data of two datasets into a single table

In Report, I need to display PO Details such as pono,item names and
their item qty,item rate, po amount, dcno., dcdate.
PO Details TenderName,pono,item name,item qty, item rate available in a
table tblPurchaseOrder.
PO amount=sum(item qty*item rate) + sum(charge)+ sum(item tax amount).
charge amount, tax amount may/may not exist for PO.
Each PO can have more than one DC.
using single query if i am trying to retreive pono,item name,po amount,
dc date,dcno then i am getting po amount no. of times dc
occurs*original po amount.so i splitted po details and dc details into
two. now the data i am getting is correct. but using two tables the
data is not corresponding to each other. dc details getting ups and
downs.
Kindly give me solution ...
My query to retreive PO Details is as follows :
SELECT viewPurchaseOrderComponents.TenderName,
viewPurchaseOrderComponents.PONo, viewPurchaseOrderComponents.PODate,
viewPurchaseOrderComponents.ComponentName,
viewPurchaseOrderComponents.ComponentQty,
viewPurchaseOrderComponents.Rate,
viewPurchaseOrderComponents.ComponentQty *
viewPurchaseOrderComponents.Rate AS CompAmount,
viewPurchaseOrderComponents.UnitName,
B.TotalTaxAmount, A.Charge,
viewPurchaseOrderComponents.ProjectComponentId,
viewPurchaseOrderComponents.ComponentId,
viewPurchaseOrderComponents.IndentNo, tblPurchaseOrder.PaymentTerms,
tblPurchaseOrder.IndentDate,
tblPurchaseOrder.DeliveryPeriod, tblPurchaseOrder.Status,
tblPurchaseOrder.HasAnyAmendment,
tblPurchaseOrder.IsRegularize,
viewPurchaseOrderComponents.Type, viewPurchaseOrderComponents.Supplier
FROM viewPurchaseOrderComponents INNER JOIN
tblPurchaseOrder ON
viewPurchaseOrderComponents.PONo = tblPurchaseOrder.PONo LEFT OUTER
JOIN
(SELECT PONo, SUM(Amount) AS Charge
FROM tblPOCharges
GROUP BY PONo) AS A ON A.PONo = viewPurchaseOrderComponents.PONo LEFT OUTER JOIN
(SELECT POComponentId,
SUM(TaxValue) AS TotalTaxAmount
FROM tblPOComponentTaxes
GROUP BY POComponentId) AS B ON
B.POComponentId = viewPurchaseOrderComponents.ComponentId
WHERE (viewPurchaseOrderComponents.PODate >= @.StartDate) AND
(viewPurchaseOrderComponents.PODate < DATEADD(d, 1, @.EndDate))
For DC Details :
SELECT viewPurchaseOrderComponents.PONo,
viewPurchaseOrderComponents.TenderName,
viewPurchaseOrderComponents.PODate,
viewPurchaseOrderComponents.ComponentName,
tblPurchaseOrder.Status, tblPurchaseOrder.HasAnyAmendment,
tblPurchaseOrder.IsRegularize,
viewPurchaseOrderComponents.Type, viewPurchaseOrderComponents.Supplier,
tblComponentsOfDc.Qty AS DCQty,
tblDeliveryChallan.DCId, CONVERT(varchar(11),
tblDeliveryChallan.ChallanDate, 106) AS ChallanDate
FROM viewPurchaseOrderComponents LEFT OUTER JOIN
tblDeliveryChallan ON tblDeliveryChallan.PONo
= viewPurchaseOrderComponents.PONo INNER JOIN
tblPurchaseOrder ON
viewPurchaseOrderComponents.PONo = tblPurchaseOrder.PONo LEFT OUTER
JOIN
tblComponentsOfDc ON tblDeliveryChallan.DCId = tblComponentsOfDc.DCId
WHERE (viewPurchaseOrderComponents.PODate >= @.StartDate) AND
(viewPurchaseOrderComponents.PODate < DATEADD(d, 1, @.EndDate))
In a single table i need TenderName,PONO,item details name,qty,rate
POAmount, DCDate...
Waiting for solution ...Try looking at subreports. You can embed a subreport into a detail line of a
table. Add an extra detail line and then drag and drop your subreport onto
the cell. Then right mouse click, properties and set the parameters to the
field values that link the two together.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sarada" <sarada_devi_i@.yahoo.com> wrote in message
news:1155904374.494550.59260@.i3g2000cwc.googlegroups.com...
> In Report, I need to display PO Details such as pono,item names and
> their item qty,item rate, po amount, dcno., dcdate.
> PO Details TenderName,pono,item name,item qty, item rate available in a
> table tblPurchaseOrder.
> PO amount=sum(item qty*item rate) + sum(charge)+ sum(item tax amount).
> charge amount, tax amount may/may not exist for PO.
> Each PO can have more than one DC.
> using single query if i am trying to retreive pono,item name,po amount,
> dc date,dcno then i am getting po amount no. of times dc
> occurs*original po amount.so i splitted po details and dc details into
> two. now the data i am getting is correct. but using two tables the
> data is not corresponding to each other. dc details getting ups and
> downs.
> Kindly give me solution ...
> My query to retreive PO Details is as follows :
> SELECT viewPurchaseOrderComponents.TenderName,
> viewPurchaseOrderComponents.PONo, viewPurchaseOrderComponents.PODate,
> viewPurchaseOrderComponents.ComponentName,
> viewPurchaseOrderComponents.ComponentQty,
> viewPurchaseOrderComponents.Rate,
> viewPurchaseOrderComponents.ComponentQty *
> viewPurchaseOrderComponents.Rate AS CompAmount,
> viewPurchaseOrderComponents.UnitName,
> B.TotalTaxAmount, A.Charge,
> viewPurchaseOrderComponents.ProjectComponentId,
> viewPurchaseOrderComponents.ComponentId,
> viewPurchaseOrderComponents.IndentNo, tblPurchaseOrder.PaymentTerms,
> tblPurchaseOrder.IndentDate,
> tblPurchaseOrder.DeliveryPeriod, tblPurchaseOrder.Status,
> tblPurchaseOrder.HasAnyAmendment,
> tblPurchaseOrder.IsRegularize,
> viewPurchaseOrderComponents.Type, viewPurchaseOrderComponents.Supplier
> FROM viewPurchaseOrderComponents INNER JOIN
> tblPurchaseOrder ON
> viewPurchaseOrderComponents.PONo = tblPurchaseOrder.PONo LEFT OUTER
> JOIN
> (SELECT PONo, SUM(Amount) AS Charge
> FROM tblPOCharges
> GROUP BY PONo) AS A ON A.PONo => viewPurchaseOrderComponents.PONo LEFT OUTER JOIN
> (SELECT POComponentId,
> SUM(TaxValue) AS TotalTaxAmount
> FROM tblPOComponentTaxes
> GROUP BY POComponentId) AS B ON
> B.POComponentId = viewPurchaseOrderComponents.ComponentId
> WHERE (viewPurchaseOrderComponents.PODate >= @.StartDate) AND
> (viewPurchaseOrderComponents.PODate < DATEADD(d, 1, @.EndDate))
> For DC Details :
> SELECT viewPurchaseOrderComponents.PONo,
> viewPurchaseOrderComponents.TenderName,
> viewPurchaseOrderComponents.PODate,
> viewPurchaseOrderComponents.ComponentName,
> tblPurchaseOrder.Status, tblPurchaseOrder.HasAnyAmendment,
> tblPurchaseOrder.IsRegularize,
> viewPurchaseOrderComponents.Type, viewPurchaseOrderComponents.Supplier,
> tblComponentsOfDc.Qty AS DCQty,
> tblDeliveryChallan.DCId, CONVERT(varchar(11),
> tblDeliveryChallan.ChallanDate, 106) AS ChallanDate
> FROM viewPurchaseOrderComponents LEFT OUTER JOIN
> tblDeliveryChallan ON tblDeliveryChallan.PONo
> = viewPurchaseOrderComponents.PONo INNER JOIN
> tblPurchaseOrder ON
> viewPurchaseOrderComponents.PONo = tblPurchaseOrder.PONo LEFT OUTER
> JOIN
> tblComponentsOfDc ON tblDeliveryChallan.DCId => tblComponentsOfDc.DCId
> WHERE (viewPurchaseOrderComponents.PODate >= @.StartDate) AND
> (viewPurchaseOrderComponents.PODate < DATEADD(d, 1, @.EndDate))
> In a single table i need TenderName,PONO,item details name,qty,rate
> POAmount, DCDate...
> Waiting for solution ...
>

Can I change Sort order configuration for a single column?

Hi,
I wanted to know, if there is a way to change the sort order (Collation) for a particular column. Assuming, sql server is configured for Case Insensitive, can I change the sort order to "Case sensitive" for a single column or object, retaining the entire sql server instance to Case insenstive
Thank
GYKTry COLLATE.
USE NORTHWIND
select * from orders
order by shipname COLLATE Latin1_General_CS_AS
There is a lot to read about in BO.
cheers,
Herbert Albert
"GYK" <anonymous@.discussions.microsoft.com> schrieb im Newsbeitrag
news:E309852D-B260-441A-BB31-676AA92D2346@.microsoft.com...
> Hi,
> I wanted to know, if there is a way to change the sort order (Collation)
for a particular column. Assuming, sql server is configured for Case
Insensitive, can I change the sort order to "Case sensitive" for a single
column or object, retaining the entire sql server instance to Case
insenstive ?
> Thanks
> GYK|||Yes, you can do that using ALTER TABLE ... ALTER COLUMN and specify the
desired collation. Or specify collation in the query, as per Herbert's
example.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:E309852D-B260-441A-BB31-676AA92D2346@.microsoft.com...
> Hi,
> I wanted to know, if there is a way to change the sort order (Collation)
for a particular column. Assuming, sql server is configured for Case
Insensitive, can I change the sort order to "Case sensitive" for a single
column or object, retaining the entire sql server instance to Case
insenstive ?
> Thanks
> GYK|||Great...
Thanks a lot to you guys
GYK|||HI,
I have one more question. Can a collation be set for a user session? That is I logon with a particular collation, and it becomes invalid, once I logout... :-)
Thanks agai
GY|||Unfortunately not. Consider sending a request for such a feature to
sqlwish@.microsoft.com.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"GYK" <anonymous@.discussions.microsoft.com> wrote in message
news:714D7DFF-E243-4B19-9545-F76BF40E475B@.microsoft.com...
> HI,
> I have one more question. Can a collation be set for a user session? That
is I logon with a particular collation, and it becomes invalid, once I
logout... :-)
> Thanks again
> GYK
>

Can I change database in shared data source?

Hi all,
I have several reports using single shared datasource. I want to
change at a runtime database that is used by that datasource. Can this
be achieved? If not what are the other solutions - I guess that using
not shared datasource for each report may be the solution (is it?) but
it is possible for me. Can database name be changed in shared
datasource? My goal is to allow users to run the same set of reports,
viewed in ReportViewer control, but using different databases
(connection string dependant).
Thanks in advance for any suggestionsMay be to crarify a bit. I have to use shared datasource. So there are
two solutions for me. 1) Change database in shared datasource. 2)
Switch between datasources
Alas none of them appears to be possible at a runtime.
Please help.
On Mar 20, 2:54 pm, "Tomaszek" <Tomasz...@.gmail.com> wrote:
> Hi all,
> I have several reports using single shared datasource. I want to
> change at a runtime database that is used by that datasource. Can this
> be achieved? If not what are the other solutions - I guess that using
> not shared datasource for each report may be the solution (is it?) but
> it is possible for me. Can database name be changed in shared
> datasource? My goal is to allow users to run the same set of reports,
> viewed in ReportViewer control, but using different databases
> (connection string dependant).
> Thanks in advance for any suggestions|||You can do this in SQL 2005. Your datasource can be an expression (you can
have a parameter that is used to specify the database).
Check books on line. I haven't done this but I know it is a feature that was
added in 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tomaszek" <TomaszekS@.gmail.com> wrote in message
news:1174403172.440357.73260@.e1g2000hsg.googlegroups.com...
> May be to crarify a bit. I have to use shared datasource. So there are
> two solutions for me. 1) Change database in shared datasource. 2)
> Switch between datasources
> Alas none of them appears to be possible at a runtime.
> Please help.
>
> On Mar 20, 2:54 pm, "Tomaszek" <Tomasz...@.gmail.com> wrote:
>> Hi all,
>> I have several reports using single shared datasource. I want to
>> change at a runtime database that is used by that datasource. Can this
>> be achieved? If not what are the other solutions - I guess that using
>> not shared datasource for each report may be the solution (is it?) but
>> it is possible for me. Can database name be changed in shared
>> datasource? My goal is to allow users to run the same set of reports,
>> viewed in ReportViewer control, but using different databases
>> (connection string dependant).
>> Thanks in advance for any suggestions
>|||But I'm affraid that it can be expression only in non shared
datasource :(
Tommy
On Mar 20, 3:11 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You can do this in SQL 2005. Your datasource can be an expression (you can
> have a parameter that is used to specify the database).
> Check books on line. I haven't done this but I know it is a feature that was
> added in 2005.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Tomaszek" <Tomasz...@.gmail.com> wrote in message
> news:1174403172.440357.73260@.e1g2000hsg.googlegroups.com...
>
> > May be to crarify a bit. I have to use shared datasource. So there are
> > two solutions for me. 1) Change database in shared datasource. 2)
> > Switch between datasources
> > Alas none of them appears to be possible at a runtime.
> > Please help.
> > On Mar 20, 2:54 pm, "Tomaszek" <Tomasz...@.gmail.com> wrote:
> >> Hi all,
> >> I have several reports using single shared datasource. I want to
> >> change at a runtime database that is used by that datasource. Can this
> >> be achieved? If not what are the other solutions - I guess that using
> >> not shared datasource for each report may be the solution (is it?) but
> >> it is possible for me. Can database name be changed in shared
> >> datasource? My goal is to allow users to run the same set of reports,
> >> viewed in ReportViewer control, but using different databases
> >> (connection string dependant).
> >> Thanks in advance for any suggestions- Hide quoted text -
> - Show quoted text -sql

Can I achieve WITH(NOLOCK) on all joins in a stored procedure with a single command?

I have a number of reporting stored procedures that purely list
records and make no changes to the data. I have noticed that some of
these SPs are causing blocks so I am adding the WITH(NOLOCK) hint. For
a simple example :-
Select * from table1 WITH(NOLOCK)
INNER JOIN table2 WITH(NOLOCK) ON table1.UID=table2.UID
INNER JOIN table3 WITH(NOLOCK) ON table1.AnotherID=table3.AnotherID
LEFT OUTER JOIN table4 WITH(NOLOCK) ON table3.ThisID=table4.ThisID
There lots of these and many of them have lots of joins so I'm looking
for a way to apply WITH(NOLOCK) to the whole procedure and save myself
the time it takes to add the hint to each table/join. I know that it
is possible to use SET DEADLOCK_PRIORITY LOW, forcing the procedure to
volunteer as the deadlock victim, but this isn't suitable as I need
the procedure to return it's records.
Does anybody have a suggestion or am I looking ata couple of days of
ctrl-v'ing WITH(NOLOCK) everywhere?
Thanks,
LiamHow about below?
SET STRANSACTION ISOLATION LEVEL READ UNCOMMITTED
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Liam Weston" <liam_weston@.hotmail.com> wrote in message
news:5f9a8c3b.0310310227.436b158b@.posting.google.com...
> I have a number of reporting stored procedures that purely list
> records and make no changes to the data. I have noticed that some of
> these SPs are causing blocks so I am adding the WITH(NOLOCK) hint. For
> a simple example :-
> Select * from table1 WITH(NOLOCK)
> INNER JOIN table2 WITH(NOLOCK) ON table1.UID=table2.UID
> INNER JOIN table3 WITH(NOLOCK) ON table1.AnotherID=table3.AnotherID
> LEFT OUTER JOIN table4 WITH(NOLOCK) ON table3.ThisID=table4.ThisID
> There lots of these and many of them have lots of joins so I'm looking
> for a way to apply WITH(NOLOCK) to the whole procedure and save myself
> the time it takes to add the hint to each table/join. I know that it
> is possible to use SET DEADLOCK_PRIORITY LOW, forcing the procedure to
> volunteer as the deadlock victim, but this isn't suitable as I need
> the procedure to return it's records.
> Does anybody have a suggestion or am I looking ata couple of days of
> ctrl-v'ing WITH(NOLOCK) everywhere?
> Thanks,
> Liam|||Thanks, that's just what I was looking for.
Liam
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in message news:<uvCEm35nDHA.2312@.TK2MSFTNGP12.phx.gbl>...
> How about below?
> SET STRANSACTION ISOLATION LEVEL READ UNCOMMITTED
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Liam Weston" <liam_weston@.hotmail.com> wrote in message
> news:5f9a8c3b.0310310227.436b158b@.posting.google.com...
> > I have a number of reporting stored procedures that purely list
> > records and make no changes to the data. I have noticed that some of
> > these SPs are causing blocks so I am adding the WITH(NOLOCK) hint. For
> > a simple example :-
> >
> > Select * from table1 WITH(NOLOCK)
> > INNER JOIN table2 WITH(NOLOCK) ON table1.UID=table2.UID
> > INNER JOIN table3 WITH(NOLOCK) ON table1.AnotherID=table3.AnotherID
> > LEFT OUTER JOIN table4 WITH(NOLOCK) ON table3.ThisID=table4.ThisID
> >
> > There lots of these and many of them have lots of joins so I'm looking
> > for a way to apply WITH(NOLOCK) to the whole procedure and save myself
> > the time it takes to add the hint to each table/join. I know that it
> > is possible to use SET DEADLOCK_PRIORITY LOW, forcing the procedure to
> > volunteer as the deadlock victim, but this isn't suitable as I need
> > the procedure to return it's records.
> >
> > Does anybody have a suggestion or am I looking ata couple of days of
> > ctrl-v'ing WITH(NOLOCK) everywhere?
> >
> > Thanks,
> >
> > Liam

can clustering use as load balacing

I want to have 3 MSSQL server that work at same time on shared
database(all opened a single data file on SAN for example). And request
for queries are send to those parallel and same sql servers to archive
more processing power and fail over feature?act as load balancing?
what can I do for load balancing heavy traffic queries like which can
done on web server?
thanks
SQL Server does not support shared-disk clustering for load balancing, though
there is a feature in SQL2005 called scalable shared database that allows you
to present the same database via a LUN to multiple SQL2005 instances for
read-only access.
Linchi
"Tarvirdi" wrote:

> I want to have 3 MSSQL server that work at same time on shared
> database(all opened a single data file on SAN for example). And request
> for queries are send to those parallel and same sql servers to archive
> more processing power and fail over feature?act as load balancing?
> what can I do for load balancing heavy traffic queries like which can
> done on web server?
> thanks
>
|||Linchi Shea wrote:
> SQL Server does not support shared-disk clustering for load balancing, though
> there is a feature in SQL2005 called scalable shared database that allows you
> to present the same database via a LUN to multiple SQL2005 instances for
> read-only access.
Dear Linchi,
Thanks for your response.
What you mean about sharing datafile?
For example I have A database named T1 with T1.mdf and want to have
another Database on other server(or same server to start test) and have
read only access to above T1.mdf? how implement it? which steps should I do?
I tried but failed because of "can create already exist file error"
Thanks
|||
> For example I have A database named T1 with T1.mdf and want to have
> another Database on other server(or same server to start test) and have
> read only access to above T1.mdf?
You can not do this
The limitation is NTFS, NTFS you can only have on server accessing the
volume at a time.
You can not do this on the same host either as SQL will have a problem
(cache comes to mind first)
the answer to your original question:
Q: can clustering be used as load balancing for SQL ?
A: no
|||
> there is a feature in SQL2005 called scalable shared database that allows
you
> to present the same database via a LUN to multiple SQL2005 instances for
> read-only access.
correct, but that is a "static" disk, presented RO to multiple hosts
you cannot have one host "writing" to and others "reading" from the same
disk

Can a single table be used for cube?

Hi,
Maybe a silly question since I am new to SW/OLAP/etc. etc.
I was wondering that if I have a single table having all the things that
can be used as 'measures' PLUS all the possible information about
dimensions in the same table.
Basically this would end up with a highly un-normalized table but
wouldn't it give a very good performance since there will be no joins
required.
I'll appreciate feedback and guidance from the experienced audience.
Thanks.I'm not sure it would give good performance. Consider a star schema with a
date dimension, for example. To know what values are available for the dime
nsion, it's compacted into this nice small table that only has to deal with
dates. If you denormalized
all of that into one table, then you'd have to scan the whole table to know
what dates are available for slicing and dicing.
If you did that with all of your dimensions, you'd end up having to scan the
whole table several times to get all of the possible values for slicing and
dicing. You could, I suppose, index those, but now you've created some ove
rhead where you didn't have
it before.
Besides--and I'm just guessing here--I would think that under the covers the
re's not really a join going on anyway. The IDs for the dimensions are prob
ably used for retrieving data from the fact table.|||Hi,
Thanks for the reply. Based on my findings over the past few days, I
have concluded that having only a single table to be used for the fact
table as well as dimension will be a VERY BAD APPROACH so I agree
with your suggestions.
To answer your question: Yes I wan not planning on any joins... the
single table would have been being available after running a DTS over
night which would have done the joining which many tables to give me the
single highly un-normalized table...
But you know what; to be honest this is where I do get a little confused
though because though there are many advantages of normalization, the
performance from an un normalized table is supposed to be far
superior... I guess the counter argument to this would be your own
comment I.e. "If you did that with all of your dimensions, you'd end up
having to scan the whole table several times to get all of the possible
values for slicing and dicing..." and as I understand and assume, this
would result in the calculated aggregations taking up a lot of space on
the Hard disk (server's or local PC's - depending on whether I am using
ROLAP, MOLAP, HOLAP, WOWLAP )
Please DO comment in response to my mail as it will help my confirm my
understanding of many things so far.
Thanks again for the reply and regards.

> I'm not sure it would give good performance. Consider a star schema with
a date
> dimension, for example. To know what values are available for the dimensi
on, it's
> compacted into this nice small table that only has to deal with dates. If
you
> denormalized all of that into one table, then you'd have to scan the whole
table
> to know what dates are available for slicing and dicing.
> If you did that with all of your dimensions, you'd end up having to scan t
he
> whole table several times to get all of the possible values for slicing an
d
> dicing. You could, I suppose, index those, but now you've created some ov
erhead
> where you didn't have it before.
> Besides--and I'm just guessing here--I would think that under the covers t
here's
> not really a join going on anyway. The IDs for the dimensions are probabl
y
> used for retrieving data from the fact table.
>

Can a single table be used for cube?

Hi,
Maybe a silly question since I am new to SW/OLAP/etc. etc.
I was wondering that if I have a single table having all the things that
can be used as 'measures' PLUS all the possible information about
dimensions in the same table.
Basically this would end up with a highly un-normalized table but
wouldn't it give a very good performance since there will be no joins
required.
I'll appreciate feedback and guidance from the experienced audience.
Thanks.
I'm not sure it would give good performance. Consider a star schema with a date dimension, for example. To know what values are available for the dimension, it's compacted into this nice small table that only has to deal with dates. If you denormalized
all of that into one table, then you'd have to scan the whole table to know what dates are available for slicing and dicing.
If you did that with all of your dimensions, you'd end up having to scan the whole table several times to get all of the possible values for slicing and dicing. You could, I suppose, index those, but now you've created some overhead where you didn't have
it before.
Besides--and I'm just guessing here--I would think that under the covers there's not really a join going on anyway. The IDs for the dimensions are probably used for retrieving data from the fact table.
|||Hi,
Thanks for the reply. Based on my findings over the past few days, I
have concluded that having only a single table to be used for the fact
table as well as dimension will be a VERY BAD APPROACH so I agree
with your suggestions.
To answer your question: Yes I wan not planning on any joins... the
single table would have been being available after running a DTS over
night which would have done the joining which many tables to give me the
single highly un-normalized table...
But you know what; to be honest this is where I do get a little confused
though because though there are many advantages of normalization, the
performance from an un normalized table is supposed to be far
superior... I guess the counter argument to this would be your own
comment I.e. "If you did that with all of your dimensions, you'd end up
having to scan the whole table several times to get all of the possible
values for slicing and dicing..." and as I understand and assume, this
would result in the calculated aggregations taking up a lot of space on
the Hard disk (server's or local PC's - depending on whether I am using
ROLAP, MOLAP, HOLAP, WOWLAP )
Please DO comment in response to my mail as it will help my confirm my
understanding of many things so far.
Thanks again for the reply and regards.

> I'm not sure it would give good performance. Consider a star schema with a date
> dimension, for example. To know what values are available for the dimension, it's
> compacted into this nice small table that only has to deal with dates. If you
> denormalized all of that into one table, then you'd have to scan the whole table
> to know what dates are available for slicing and dicing.
> If you did that with all of your dimensions, you'd end up having to scan the
> whole table several times to get all of the possible values for slicing and
> dicing. You could, I suppose, index those, but now you've created some overhead
> where you didn't have it before.
> Besides--and I'm just guessing here--I would think that under the covers there's
> not really a join going on anyway. The IDs for the dimensions are probably
> used for retrieving data from the fact table.
>

Can a burrito corrupt a single user's records?

I have a user of SQL-based CRM application. She is the only one who is
unable to see her associated contact records. She is also the only user on
the same electrical circuit as the kitchen at one of our offices. One day
someone was microwaving a frozen burrito and blew the circuit breaker. The
lights in the kitchen went out, the fridge and microwave stopped, and the PC
which had the application open, lost power. Has anyone else seen incidents
where power loss corrupts not an entire DB but an individual's records? Is
there a burrito brand that can prevent this from recurring (jk). Thanks,
Pancho.The important question is, was this a plain burrito, or was there cheese
involved? Oh, and I should probably also ask, black beans or pintos?
While you're figuring out the answer to that one, run DBCC CHECKDB on your
database and see if you can repair the issues. There may be more corruption
you're not seeing simply because no one else has retrieved the rows -- yet.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> I have a user of SQL-based CRM application. She is the only one who is
> unable to see her associated contact records. She is also the only user
on
> the same electrical circuit as the kitchen at one of our offices. One day
> someone was microwaving a frozen burrito and blew the circuit breaker.
The
> lights in the kitchen went out, the fridge and microwave stopped, and the
PC
> which had the application open, lost power. Has anyone else seen
incidents
> where power loss corrupts not an entire DB but an individual's records?
Is
> there a burrito brand that can prevent this from recurring (jk). Thanks,
> Pancho.|||If the burrito is the culprit, I would like to suggest that it be called
Bandito Burrito... ;-)
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
>I have a user of SQL-based CRM application. She is the only one who is
> unable to see her associated contact records. She is also the only user
> on
> the same electrical circuit as the kitchen at one of our offices. One day
> someone was microwaving a frozen burrito and blew the circuit breaker.
> The
> lights in the kitchen went out, the fridge and microwave stopped, and the
> PC
> which had the application open, lost power. Has anyone else seen
> incidents
> where power loss corrupts not an entire DB but an individual's records?
> Is
> there a burrito brand that can prevent this from recurring (jk). Thanks,
> Pancho.|||MSDN has covered this topic in depth:
http://msdn.microsoft.com/products/...px?item=burrito
(ok, so I was having a little querystring fun... it's Friday, sue me.)
Pancho wrote:
>I have a user of SQL-based CRM application. She is the only one who is
>unable to see her associated contact records. She is also the only user on
>the same electrical circuit as the kitchen at one of our offices. One day
>someone was microwaving a frozen burrito and blew the circuit breaker. The
>lights in the kitchen went out, the fridge and microwave stopped, and the P
C
>which had the application open, lost power. Has anyone else seen incidents
>where power loss corrupts not an entire DB but an individual's records? Is
>there a burrito brand that can prevent this from recurring (jk). Thanks,
>Pancho.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200508/1|||Can u send that burrito ,me i want to test on my production database
with 200 users.
They all are hungry
thanx this helps u
from
killer|||You got the path wrong:
http://msdn.microsoft.com/products/...px?item=burrito
:D
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Frefaln via droptable.com" <forum@.droptable.com> wrote in message
news:52BE5071FF4C0@.droptable.com...
> MSDN has covered this topic in depth:
>
http://msdn.microsoft.com/products/...burrito

>
> (ok, so I was having a little querystring fun... it's Friday, sue me.)
>
> Pancho wrote:
on[vbcol=seagreen]
day[vbcol=seagreen]
The[vbcol=seagreen]
PC[vbcol=seagreen]
incidents[vbcol=seagreen]
Is[vbcol=seagreen]
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200508/1|||I like it when somebody add a little bit of humor to our everyday problems.
Adding to what Adam said, check if the property "TORN_PAGE_DETECTION" is on
in this db.
AMB
"Adam Machanic" wrote:

> The important question is, was this a plain burrito, or was there cheese
> involved? Oh, and I should probably also ask, black beans or pintos?
> While you're figuring out the answer to that one, run DBCC CHECKDB on your
> database and see if you can repair the issues. There may be more corrupti
on
> you're not seeing simply because no one else has retrieved the rows -- yet
.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> on
> The
> PC
> incidents
> Is
>
>|||Perhaps a variant of Montezuma's Revenge?
"ChrisR" wrote:

> If the burrito is the culprit, I would like to suggest that it be called
> Bandito Burrito... ;-)
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
>
>|||Me too. But it really did happen!
"Frefaln via droptable.com" wrote:

> MSDN has covered this topic in depth:
> http://msdn.microsoft.com/products/...px?item=burrito
>
> (ok, so I was having a little querystring fun... it's Friday, sue me.)
>
> Pancho wrote:
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200508/1
>|||Adam:
1. Thanks for the DBCC suggestion.
2. Early reports are that it was beef, bean and cheese. It may have been
the Tina's brand which are cheap but good.
3. Our engineers are attempting a workaround by running the microwave in
"Thaw" mode first to soften the burrito, then zapping it at full power to
heat before eating, for a briefer time period.

"Adam Machanic" wrote:

> The important question is, was this a plain burrito, or was there cheese
> involved? Oh, and I should probably also ask, black beans or pintos?
> While you're figuring out the answer to that one, run DBCC CHECKDB on your
> database and see if you can repair the issues. There may be more corrupti
on
> you're not seeing simply because no one else has retrieved the rows -- yet
.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> on
> The
> PC
> incidents
> Is
>
>

Can a burrito corrupt a single user's records?

I have a user of SQL-based CRM application. She is the only one who is
unable to see her associated contact records. She is also the only user on
the same electrical circuit as the kitchen at one of our offices. One day
someone was microwaving a frozen burrito and blew the circuit breaker. The
lights in the kitchen went out, the fridge and microwave stopped, and the PC
which had the application open, lost power. Has anyone else seen incidents
where power loss corrupts not an entire DB but an individual's records? Is
there a burrito brand that can prevent this from recurring (jk). Thanks,
Pancho.
The important question is, was this a plain burrito, or was there cheese
involved? Oh, and I should probably also ask, black beans or pintos?
While you're figuring out the answer to that one, run DBCC CHECKDB on your
database and see if you can repair the issues. There may be more corruption
you're not seeing simply because no one else has retrieved the rows -- yet.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> I have a user of SQL-based CRM application. She is the only one who is
> unable to see her associated contact records. She is also the only user
on
> the same electrical circuit as the kitchen at one of our offices. One day
> someone was microwaving a frozen burrito and blew the circuit breaker.
The
> lights in the kitchen went out, the fridge and microwave stopped, and the
PC
> which had the application open, lost power. Has anyone else seen
incidents
> where power loss corrupts not an entire DB but an individual's records?
Is
> there a burrito brand that can prevent this from recurring (jk). Thanks,
> Pancho.
|||If the burrito is the culprit, I would like to suggest that it be called
Bandito Burrito... ;-)
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
>I have a user of SQL-based CRM application. She is the only one who is
> unable to see her associated contact records. She is also the only user
> on
> the same electrical circuit as the kitchen at one of our offices. One day
> someone was microwaving a frozen burrito and blew the circuit breaker.
> The
> lights in the kitchen went out, the fridge and microwave stopped, and the
> PC
> which had the application open, lost power. Has anyone else seen
> incidents
> where power loss corrupts not an entire DB but an individual's records?
> Is
> there a burrito brand that can prevent this from recurring (jk). Thanks,
> Pancho.
|||MSDN has covered this topic in depth:
http://msdn.microsoft.com/products/S...x?item=burrito
(ok, so I was having a little querystring fun... it's Friday, sue me.)
Pancho wrote:
>I have a user of SQL-based CRM application. She is the only one who is
>unable to see her associated contact records. She is also the only user on
>the same electrical circuit as the kitchen at one of our offices. One day
>someone was microwaving a frozen burrito and blew the circuit breaker. The
>lights in the kitchen went out, the fridge and microwave stopped, and the PC
>which had the application open, lost power. Has anyone else seen incidents
>where power loss corrupts not an entire DB but an individual's records? Is
>there a burrito brand that can prevent this from recurring (jk). Thanks,
>Pancho.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200508/1
|||Can u send that burrito ,me i want to test on my production database
with 200 users.
They all are hungry
thanx this helps u
from
killer
|||You got the path wrong:
http://msdn.microsoft.com/products/S...x?item=burrito
:D
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"Frefaln via droptable.com" <forum@.droptable.com> wrote in message
news:52BE5071FF4C0@.droptable.com...
> MSDN has covered this topic in depth:
>
http://msdn.microsoft.com/products/S...x?item=burrito[vbcol=seagreen]
>
> (ok, so I was having a little querystring fun... it's Friday, sue me.)
>
> Pancho wrote:
on[vbcol=seagreen]
day[vbcol=seagreen]
The[vbcol=seagreen]
PC[vbcol=seagreen]
incidents[vbcol=seagreen]
Is
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200508/1
|||I like it when somebody add a little bit of humor to our everyday problems.
Adding to what Adam said, check if the property "TORN_PAGE_DETECTION" is on
in this db.
AMB
"Adam Machanic" wrote:

> The important question is, was this a plain burrito, or was there cheese
> involved? Oh, and I should probably also ask, black beans or pintos?
> While you're figuring out the answer to that one, run DBCC CHECKDB on your
> database and see if you can repair the issues. There may be more corruption
> you're not seeing simply because no one else has retrieved the rows -- yet.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> on
> The
> PC
> incidents
> Is
>
>
|||Perhaps a variant of Montezuma's Revenge?
"ChrisR" wrote:

> If the burrito is the culprit, I would like to suggest that it be called
> Bandito Burrito... ;-)
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
>
>
|||Me too. But it really did happen!
"Frefaln via droptable.com" wrote:

> MSDN has covered this topic in depth:
> http://msdn.microsoft.com/products/S...x?item=burrito
>
> (ok, so I was having a little querystring fun... it's Friday, sue me.)
>
> Pancho wrote:
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200508/1
>
|||Adam:
1. Thanks for the DBCC suggestion.
2. Early reports are that it was beef, bean and cheese. It may have been
the Tina's brand which are cheap but good.
3. Our engineers are attempting a workaround by running the microwave in
"Thaw" mode first to soften the burrito, then zapping it at full power to
heat before eating, for a briefer time period.

"Adam Machanic" wrote:

> The important question is, was this a plain burrito, or was there cheese
> involved? Oh, and I should probably also ask, black beans or pintos?
> While you're figuring out the answer to that one, run DBCC CHECKDB on your
> database and see if you can repair the issues. There may be more corruption
> you're not seeing simply because no one else has retrieved the rows -- yet.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> on
> The
> PC
> incidents
> Is
>
>

Can a burrito corrupt a single user's records?

I have a user of SQL-based CRM application. She is the only one who is
unable to see her associated contact records. She is also the only user on
the same electrical circuit as the kitchen at one of our offices. One day
someone was microwaving a frozen burrito and blew the circuit breaker. The
lights in the kitchen went out, the fridge and microwave stopped, and the PC
which had the application open, lost power. Has anyone else seen incidents
where power loss corrupts not an entire DB but an individual's records? Is
there a burrito brand that can prevent this from recurring (jk). Thanks,
Pancho.The important question is, was this a plain burrito, or was there cheese
involved? Oh, and I should probably also ask, black beans or pintos?
While you're figuring out the answer to that one, run DBCC CHECKDB on your
database and see if you can repair the issues. There may be more corruption
you're not seeing simply because no one else has retrieved the rows -- yet.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> I have a user of SQL-based CRM application. She is the only one who is
> unable to see her associated contact records. She is also the only user
on
> the same electrical circuit as the kitchen at one of our offices. One day
> someone was microwaving a frozen burrito and blew the circuit breaker.
The
> lights in the kitchen went out, the fridge and microwave stopped, and the
PC
> which had the application open, lost power. Has anyone else seen
incidents
> where power loss corrupts not an entire DB but an individual's records?
Is
> there a burrito brand that can prevent this from recurring (jk). Thanks,
> Pancho.|||If the burrito is the culprit, I would like to suggest that it be called
Bandito Burrito... ;-)
"Pancho" <Pancho@.discussions.microsoft.com> wrote in message
news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
>I have a user of SQL-based CRM application. She is the only one who is
> unable to see her associated contact records. She is also the only user
> on
> the same electrical circuit as the kitchen at one of our offices. One day
> someone was microwaving a frozen burrito and blew the circuit breaker.
> The
> lights in the kitchen went out, the fridge and microwave stopped, and the
> PC
> which had the application open, lost power. Has anyone else seen
> incidents
> where power loss corrupts not an entire DB but an individual's records?
> Is
> there a burrito brand that can prevent this from recurring (jk). Thanks,
> Pancho.|||MSDN has covered this topic in depth:
http://msdn.microsoft.com/products/SQL2k/errors/delicacies/mexican/highcarb/food.aspx?item=burrito
(ok, so I was having a little querystring fun... it's Friday, sue me.)
Pancho wrote:
>I have a user of SQL-based CRM application. She is the only one who is
>unable to see her associated contact records. She is also the only user on
>the same electrical circuit as the kitchen at one of our offices. One day
>someone was microwaving a frozen burrito and blew the circuit breaker. The
>lights in the kitchen went out, the fridge and microwave stopped, and the PC
>which had the application open, lost power. Has anyone else seen incidents
>where power loss corrupts not an entire DB but an individual's records? Is
>there a burrito brand that can prevent this from recurring (jk). Thanks,
>Pancho.
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1|||Can u send that burrito ,me i want to test on my production database
with 200 users.
They all are hungry
thanx this helps u
from
killer|||You got the path wrong:
http://msdn.microsoft.com/products/SQL2k/errors/delicacies/highcarb/mexican/food.aspx?item=burrito
:D
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"Frefaln via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:52BE5071FF4C0@.SQLMonster.com...
> MSDN has covered this topic in depth:
>
http://msdn.microsoft.com/products/SQL2k/errors/delicacies/mexican/highcarb/food.aspx?item=burrito
>
> (ok, so I was having a little querystring fun... it's Friday, sue me.)
>
> Pancho wrote:
> >I have a user of SQL-based CRM application. She is the only one who is
> >unable to see her associated contact records. She is also the only user
on
> >the same electrical circuit as the kitchen at one of our offices. One
day
> >someone was microwaving a frozen burrito and blew the circuit breaker.
The
> >lights in the kitchen went out, the fridge and microwave stopped, and the
PC
> >which had the application open, lost power. Has anyone else seen
incidents
> >where power loss corrupts not an entire DB but an individual's records?
Is
> >there a burrito brand that can prevent this from recurring (jk). Thanks,
> >Pancho.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1|||I like it when somebody add a little bit of humor to our everyday problems.
Adding to what Adam said, check if the property "TORN_PAGE_DETECTION" is on
in this db.
AMB
"Adam Machanic" wrote:
> The important question is, was this a plain burrito, or was there cheese
> involved? Oh, and I should probably also ask, black beans or pintos?
> While you're figuring out the answer to that one, run DBCC CHECKDB on your
> database and see if you can repair the issues. There may be more corruption
> you're not seeing simply because no one else has retrieved the rows -- yet.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> > I have a user of SQL-based CRM application. She is the only one who is
> > unable to see her associated contact records. She is also the only user
> on
> > the same electrical circuit as the kitchen at one of our offices. One day
> > someone was microwaving a frozen burrito and blew the circuit breaker.
> The
> > lights in the kitchen went out, the fridge and microwave stopped, and the
> PC
> > which had the application open, lost power. Has anyone else seen
> incidents
> > where power loss corrupts not an entire DB but an individual's records?
> Is
> > there a burrito brand that can prevent this from recurring (jk). Thanks,
> > Pancho.
>
>|||Perhaps a variant of Montezuma's Revenge?
"ChrisR" wrote:
> If the burrito is the culprit, I would like to suggest that it be called
> Bandito Burrito... ;-)
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> >I have a user of SQL-based CRM application. She is the only one who is
> > unable to see her associated contact records. She is also the only user
> > on
> > the same electrical circuit as the kitchen at one of our offices. One day
> > someone was microwaving a frozen burrito and blew the circuit breaker.
> > The
> > lights in the kitchen went out, the fridge and microwave stopped, and the
> > PC
> > which had the application open, lost power. Has anyone else seen
> > incidents
> > where power loss corrupts not an entire DB but an individual's records?
> > Is
> > there a burrito brand that can prevent this from recurring (jk). Thanks,
> > Pancho.
>
>|||Me too. But it really did happen!
"Frefaln via SQLMonster.com" wrote:
> MSDN has covered this topic in depth:
> http://msdn.microsoft.com/products/SQL2k/errors/delicacies/mexican/highcarb/food.aspx?item=burrito
>
> (ok, so I was having a little querystring fun... it's Friday, sue me.)
>
> Pancho wrote:
> >I have a user of SQL-based CRM application. She is the only one who is
> >unable to see her associated contact records. She is also the only user on
> >the same electrical circuit as the kitchen at one of our offices. One day
> >someone was microwaving a frozen burrito and blew the circuit breaker. The
> >lights in the kitchen went out, the fridge and microwave stopped, and the PC
> >which had the application open, lost power. Has anyone else seen incidents
> >where power loss corrupts not an entire DB but an individual's records? Is
> >there a burrito brand that can prevent this from recurring (jk). Thanks,
> >Pancho.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1
>|||Adam:
1. Thanks for the DBCC suggestion.
2. Early reports are that it was beef, bean and cheese. It may have been
the Tina's brand which are cheap but good.
3. Our engineers are attempting a workaround by running the microwave in
"Thaw" mode first to soften the burrito, then zapping it at full power to
heat before eating, for a briefer time period.
:)
"Adam Machanic" wrote:
> The important question is, was this a plain burrito, or was there cheese
> involved? Oh, and I should probably also ask, black beans or pintos?
> While you're figuring out the answer to that one, run DBCC CHECKDB on your
> database and see if you can repair the issues. There may be more corruption
> you're not seeing simply because no one else has retrieved the rows -- yet.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "Pancho" <Pancho@.discussions.microsoft.com> wrote in message
> news:0E8A27CD-039E-4892-9F7D-1CF05F878269@.microsoft.com...
> > I have a user of SQL-based CRM application. She is the only one who is
> > unable to see her associated contact records. She is also the only user
> on
> > the same electrical circuit as the kitchen at one of our offices. One day
> > someone was microwaving a frozen burrito and blew the circuit breaker.
> The
> > lights in the kitchen went out, the fridge and microwave stopped, and the
> PC
> > which had the application open, lost power. Has anyone else seen
> incidents
> > where power loss corrupts not an entire DB but an individual's records?
> Is
> > there a burrito brand that can prevent this from recurring (jk). Thanks,
> > Pancho.
>
>|||Suggest you select a pilot group of 20. Maybe 10 bean and cheese, 10 chicken
or beef. SELECT FName, Lname FROM Employees WHERE EnjoysBurritos = 1
"doller" wrote:
> Can u send that burrito ,me i want to test on my production database
> with 200 users.
> They all are hungry
>
> thanx this helps u
> from
> killer
>|||"Pancho" wrote:
> Suggest you select a pilot group of 20. Maybe 10 bean and cheese, 10 chicken
> or beef. SELECT FName, Lname FROM Employees WHERE EnjoysBurritos = 1
> "doller" wrote:
> > Can u send that burrito ,me i want to test on my production database
> > with 200 users.
> > They all are hungry
> >
> >
> > thanx this helps u
> >
> > from
> > killer
> >
> >
Im killing it man - the funniest sql thread I have ever seen :-)
(btw - your burrito is being put in as Nvarchar right?)|||Yep, time to let it. Go. Thanks everyone for a good thread. Yes, it was
Nvarchar!
pancho
"badlydressedboy" wrote:
>
> "Pancho" wrote:
> > Suggest you select a pilot group of 20. Maybe 10 bean and cheese, 10 chicken
> > or beef. SELECT FName, Lname FROM Employees WHERE EnjoysBurritos = 1
> >
> > "doller" wrote:
> >
> > > Can u send that burrito ,me i want to test on my production database
> > > with 200 users.
> > > They all are hungry
> > >
> > >
> > > thanx this helps u
> > >
> > > from
> > > killer
> > >
> > >
> Im killing it man - the funniest sql thread I have ever seen :-)
> (btw - your burrito is being put in as Nvarchar right?)

Can 2000 and 2005 coexist?

I need to manage a couple of SQL 2000 servers and a couple of 2005 servers
from a single "admin" machine. I currently have just 2000 (server & client
tools) installed on the admin machine. Is it possible to install (not
upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
both the 2005 server and client tools) Any suggestions on how to achieve
having both versions installed on the same machine?
Thank you,
Ben
Yes. I had 2000 with two instances on my machine. I installed 2005 with one (named) instance and my
2000 tools are still there. I did get a new program group with 2005 tools.
I can now admin 7.0 and 2000 servers using EM 2000.
And I can manage 2000 and 2005 servers using Management Studio.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ben Amada" <ben@.REpoMOweVErpick.com> wrote in message news:OL2oKXd5FHA.620@.TK2MSFTNGP12.phx.gbl...
>I need to manage a couple of SQL 2000 servers and a couple of 2005 servers from a single "admin"
>machine. I currently have just 2000 (server & client tools) installed on the admin machine. Is it
>possible to install (not upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
>both the 2005 server and client tools) Any suggestions on how to achieve having both versions
>installed on the same machine?
> Thank you,
> Ben
>
|||Tibor Karaszi wrote:

> Yes. I had 2000 with two instances on my machine. I installed 2005 with
> one (named) instance and my 2000 tools are still there. I did get a new
> program group with 2005 tools. I can now admin 7.0 and 2000 servers using
> EM 2000.
> And I can manage 2000 and 2005 servers using Management Studio.
That's very good news that it is possible. As soon as I get a chance, I'll
give it a try and see what happens.
Thanks,
Ben

Can 2000 and 2005 coexist?

I need to manage a couple of SQL 2000 servers and a couple of 2005 servers
from a single "admin" machine. I currently have just 2000 (server & client
tools) installed on the admin machine. Is it possible to install (not
upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
both the 2005 server and client tools) Any suggestions on how to achieve
having both versions installed on the same machine?
Thank you,
BenYes. I had 2000 with two instances on my machine. I installed 2005 with one (named) instance and my
2000 tools are still there. I did get a new program group with 2005 tools.
I can now admin 7.0 and 2000 servers using EM 2000.
And I can manage 2000 and 2005 servers using Management Studio.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ben Amada" <ben@.REpoMOweVErpick.com> wrote in message news:OL2oKXd5FHA.620@.TK2MSFTNGP12.phx.gbl...
>I need to manage a couple of SQL 2000 servers and a couple of 2005 servers from a single "admin"
>machine. I currently have just 2000 (server & client tools) installed on the admin machine. Is it
>possible to install (not upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
>both the 2005 server and client tools) Any suggestions on how to achieve having both versions
>installed on the same machine?
> Thank you,
> Ben
>|||Tibor Karaszi wrote:
> Yes. I had 2000 with two instances on my machine. I installed 2005 with
> one (named) instance and my 2000 tools are still there. I did get a new
> program group with 2005 tools. I can now admin 7.0 and 2000 servers using
> EM 2000.
> And I can manage 2000 and 2005 servers using Management Studio.
That's very good news that it is possible. As soon as I get a chance, I'll
give it a try and see what happens.
Thanks,
Ben

Can 2000 and 2005 coexist?

I need to manage a couple of SQL 2000 servers and a couple of 2005 servers
from a single "admin" machine. I currently have just 2000 (server & client
tools) installed on the admin machine. Is it possible to install (not
upgrade) SQL 2005 on the admin machine? (Preferably I'd like to install
both the 2005 server and client tools) Any suggestions on how to achieve
having both versions installed on the same machine?
Thank you,
BenYes. I had 2000 with two instances on my machine. I installed 2005 with one
(named) instance and my
2000 tools are still there. I did get a new program group with 2005 tools.
I can now admin 7.0 and 2000 servers using EM 2000.
And I can manage 2000 and 2005 servers using Management Studio.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ben Amada" <ben@.REpoMOweVErpick.com> wrote in message news:OL2oKXd5FHA.620@.TK2MSFTNGP12.phx
.gbl...
>I need to manage a couple of SQL 2000 servers and a couple of 2005 servers
from a single "admin"
>machine. I currently have just 2000 (server & client tools) installed on t
he admin machine. Is it
>possible to install (not upgrade) SQL 2005 on the admin machine? (Preferab
ly I'd like to install
>both the 2005 server and client tools) Any suggestions on how to achieve h
aving both versions
>installed on the same machine?
> Thank you,
> Ben
>|||Tibor Karaszi wrote:

> Yes. I had 2000 with two instances on my machine. I installed 2005 with
> one (named) instance and my 2000 tools are still there. I did get a new
> program group with 2005 tools. I can now admin 7.0 and 2000 servers using
> EM 2000.
> And I can manage 2000 and 2005 servers using Management Studio.
That's very good news that it is possible. As soon as I get a chance, I'll
give it a try and see what happens.
Thanks,
Ben