Tuesday, March 20, 2012
book on EVERYTHING in SQL
Transact-SQL:
The Guru's Guide to Transact SQL and XML (or something like that) by Ken Henderson
Teach Yourself Transact-SQL in 21 Days by Sam's (believe it or not)
Architecture:
Inside SQL Server by Kalen Delaney (it's the best out there)
Performance Tuning:
SQL Server 2000 Performance Tuning Manual by Microsoft Press|||Each SQL implementation is different. Of the three you've listed, there is a wide variety of syntax supported. MS-SQL implementes full SQL-92. Jet (the engine used by MS-Access) implements a large subset of SQL-87 with a lot of the SQL-92 features grafted on in peculiar ways. Oracle supports most of the features of SQL-92, but using Oracle's non-standard syntax.
I don't know of any one book that covers all of the possible SQL-like variations. I like Derrick's suggestions for MS-SQL. If you are looking for a very generic SQL overview, I'd suggest SQL for Dummies. If you want quality background that will help you understand how you should use SQL (but not get far into any particular implementation), I'd recommend Joe Celko's SQL For Smarties.
In short, I don't think exactly what you want can exist, but there are lots of choices that might be "good enough" for what you really want... You just have to pick the one that seems the closest to what you think you'll need and go from there.
-PatP
Monday, March 19, 2012
Body Size
I have report which requires a long body. But it seems RS doesnt allow body
size more than 160 inches.
Pz anybody suggests how can we overcome this problem.
ThanksWe already have report which has lists on that and in each list has
respective tables/chart and query. Now we need to add more sections to the
existing report. If I add more lists of a page size, i run out of the body.
The other option is to add sub reports. But there is issue is like We have a
table of contents on first section which verifies if the any of the section's
query doesnt return result, dont print in table of content as the same is not
going to be there in report. So to verify I need to write the same query at 2
different place.. If there is a way to find if the subreport is going to have
data or not OR Sub report can write to one of the text box in main report (
table of content), The it will be done.
Thanks !!!
"Jeff A. Stucker" wrote:
> I should have said XML tranformation instead of style sheet.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> > Why do you need such a long body size? You can get around almost anything
> > on the output side by using XML and then linking it to a style sheet.
> > That takes a bit of programming, though.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "manish" <manish@.discussions.microsoft.com> wrote in message
> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> >> Hi,
> >>
> >> I have report which requires a long body. But it seems RS doesnt allow
> >> body
> >> size more than 160 inches.
> >> Pz anybody suggests how can we overcome this problem.
> >>
> >> Thanks
> >
> >
>
>|||There is a property you can set on subreports that defines something to
display if the subreport is empty. I wonder if you can play with that...
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"manish" <manish@.discussions.microsoft.com> wrote in message
news:082B3F56-E90A-4A20-870E-DC63C8701EDF@.microsoft.com...
> We already have report which has lists on that and in each list has
> respective tables/chart and query. Now we need to add more sections to the
> existing report. If I add more lists of a page size, i run out of the
> body.
> The other option is to add sub reports. But there is issue is like We have
> a
> table of contents on first section which verifies if the any of the
> section's
> query doesnt return result, dont print in table of content as the same is
> not
> going to be there in report. So to verify I need to write the same query
> at 2
> different place.. If there is a way to find if the subreport is going to
> have
> data or not OR Sub report can write to one of the text box in main report
> (
> table of content), The it will be done.
> Thanks !!!
> "Jeff A. Stucker" wrote:
>> I should have said XML tranformation instead of style sheet.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
>> > Why do you need such a long body size? You can get around almost
>> > anything
>> > on the output side by using XML and then linking it to a style sheet.
>> > That takes a bit of programming, though.
>> >
>> > --
>> > Cheers,
>> >
>> > '(' Jeff A. Stucker
>> > \
>> >
>> > Business Intelligence
>> > www.criadvantage.com
>> > ---
>> > "manish" <manish@.discussions.microsoft.com> wrote in message
>> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
>> >> Hi,
>> >>
>> >> I have report which requires a long body. But it seems RS doesnt allow
>> >> body
>> >> size more than 160 inches.
>> >> Pz anybody suggests how can we overcome this problem.
>> >>
>> >> Thanks
>> >
>> >
>>|||Yeah! I lef with this choice only in this scenario.. Thanks Jeff !!!
"Jeff A. Stucker" wrote:
> There is a property you can set on subreports that defines something to
> display if the subreport is empty. I wonder if you can play with that...
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "manish" <manish@.discussions.microsoft.com> wrote in message
> news:082B3F56-E90A-4A20-870E-DC63C8701EDF@.microsoft.com...
> > We already have report which has lists on that and in each list has
> > respective tables/chart and query. Now we need to add more sections to the
> > existing report. If I add more lists of a page size, i run out of the
> > body.
> > The other option is to add sub reports. But there is issue is like We have
> > a
> > table of contents on first section which verifies if the any of the
> > section's
> > query doesnt return result, dont print in table of content as the same is
> > not
> > going to be there in report. So to verify I need to write the same query
> > at 2
> > different place.. If there is a way to find if the subreport is going to
> > have
> > data or not OR Sub report can write to one of the text box in main report
> > (
> > table of content), The it will be done.
> >
> > Thanks !!!
> >
> > "Jeff A. Stucker" wrote:
> >
> >> I should have said XML tranformation instead of style sheet.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> >> > Why do you need such a long body size? You can get around almost
> >> > anything
> >> > on the output side by using XML and then linking it to a style sheet.
> >> > That takes a bit of programming, though.
> >> >
> >> > --
> >> > Cheers,
> >> >
> >> > '(' Jeff A. Stucker
> >> > \
> >> >
> >> > Business Intelligence
> >> > www.criadvantage.com
> >> > ---
> >> > "manish" <manish@.discussions.microsoft.com> wrote in message
> >> > news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> >> >> Hi,
> >> >>
> >> >> I have report which requires a long body. But it seems RS doesnt allow
> >> >> body
> >> >> size more than 160 inches.
> >> >> Pz anybody suggests how can we overcome this problem.
> >> >>
> >> >> Thanks
> >> >
> >> >
> >>
> >>
> >>
>
>|||Why do you need such a long body size? You can get around almost anything
on the output side by using XML and then linking it to a style sheet. That
takes a bit of programming, though.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"manish" <manish@.discussions.microsoft.com> wrote in message
news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
> Hi,
> I have report which requires a long body. But it seems RS doesnt allow
> body
> size more than 160 inches.
> Pz anybody suggests how can we overcome this problem.
> Thanks|||I should have said XML tranformation instead of style sheet.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:Ommw5E29EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Why do you need such a long body size? You can get around almost anything
> on the output side by using XML and then linking it to a style sheet.
> That takes a bit of programming, though.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "manish" <manish@.discussions.microsoft.com> wrote in message
> news:BAB4D70A-4419-4CBD-93E3-DE52017DE032@.microsoft.com...
>> Hi,
>> I have report which requires a long body. But it seems RS doesnt allow
>> body
>> size more than 160 inches.
>> Pz anybody suggests how can we overcome this problem.
>> Thanks
>
Tuesday, February 14, 2012
BizTalk and SQL Server 2000
http://msdn2.microsoft.com/en-us/library/ms187014.aspx|||Thank you for the article. What I really need is a very detailed explanation of how a transaction log mark works. Does the system try and open the transaction log like a text file (for example) in order to put a mark in? I've got a couple of databases in BizTalk that have transaction logs that grow rather large and once they get to the 1.5 Gig to 2 Gig size SQL Server starts to throw memory errors (SQL Server Standard Edition) when the TRANSACTION WITH MARK runs. I can get rid of the memory errors by running a backup then issuing a DBCC Shrinkfile but this isn't a viable option for my production system. Since this is BizTalk I was expecting that Microsoft would have a solution to my problem. Have you seen this before?|||
When a 'with mark' is set, the system will start keeping track of every operation between the database(s) involved in the dml session. This can get rather large if there are lots of changes.
So, unless you really need 'with mark' set, don't. Especially, if you are not creating a transaction across multiple databases.
|||Aaaa, but the 'with mark' is part of the custom backup solution that is supplied with BizTalk in order to handle the fact that BizTalk uses Distributed Queries all over the system. So my ultimate question is - how do I take a consistent backup of all of the BizTalk databases so that a restore would leave them in sync.? When I asked this question of some of the folks we had help us install and configure BizTalk they gave me the stored procedure that we run as our backup which uses the "with mark". Is there an alternative?
Friday, February 10, 2012
Bit more specific, Can one pass an NVARCHAR to IF UPDATED()?
I'm still plunking away on a history trigger that requires the evaluation of whether or not each column has been updated. If it has,t hen I'll be tossing a record into a history table.
Basically I need something to function along the same logic as this:
IF UPDATED(@.s)
BEGIN
--some code
END
Any thoughts you folks may have are greatly appreciated.About the closest I can get is the Columns_Updated() and maybe some fancy dancing with syscolumns.
-PatP|||About the closest I can get is the Columns_Updated() and maybe some fancy dancing with syscolumns.
-PatP
At least it's something to go on. I'll take a look at it tomorrow.
Much obliged good sir.