Viewing 15 posts - 7,876 through 7,890 (of 8,416 total)
Trigger (5/27/2009)
Old Hand is correct! It's not Value Added Tax.
Tough crowd :pinch:
May 27, 2009 at 3:40 am
Right then.
Given the wealth of knowledge and talent around these parts, who's up for writing the perfect collaborative-effort book on indexing?
We could all get fabulously rich!!! :w00t:
Paul
May 27, 2009 at 3:37 am
SSMS doesn't always do a brilliant job checking what is possible before graying options out.
Of course sometimes it has no way to check the exact permissions required, and so makes...
May 27, 2009 at 3:31 am
To delve deeper into the complex world of memory management (especially when using 32 bit editions), I would encourage you to visit Slava Oks' WebLog.
An interesting entry to start with...
May 27, 2009 at 3:27 am
Florian Reischl (5/27/2009)
Lynn Pettis (5/26/2009)
OMG, you really have to be kidding here...Notice, more than 800 points.
Sigh!
😎
May 27, 2009 at 3:18 am
GilaMonster (5/27/2009)
Paul White (5/27/2009)
May 27, 2009 at 3:13 am
Hey wellygee,
For a range-search (range scan/seek), the lowest-cost path is often over the clustered index - so you are right about that. However, if a non-clustered index exists which...
May 27, 2009 at 2:57 am
Whether you choose aggregation tables or indexed views depends on a number of factors - not least whether the database serving the MDX-to-SQL translated queries is exclusively used by SSAS...
May 27, 2009 at 2:28 am
I tend to try quite hard to avoid keywords and other reserved terms, partly because it just seems 'wrong' somehow, but mostly because I don't like my columns to light...
May 27, 2009 at 1:55 am
wong.bing (5/26/2009)
Convert from UTC to Local date:
convert(char(10),dateAdd(hour, datediff(hour, getutcdate(), getdate()),dateadd(second, call_time, '1/1/1970')),101) =...
May 27, 2009 at 1:51 am
arun.sas (5/26/2009)
Paul White (5/26/2009)
A country where the VAT rate requires a DEC(38,2) is likely to experience civil unrest sooner rather than later. :w00t:
Never assume the VAT means “Value Added Tax”....
May 27, 2009 at 1:36 am
arun.sas (5/26/2009)
Lynn Pettis (5/26/2009)
Try this:CAST(IL.[VAT %] AS DECIMAL(4,2)) AS 'VAT'
but the orignal datatype is Decimal(38,20),
so,its may better to use this like
CAST(ABC AS DECIMAL(38,2)) AS 'VAT'
A country where the VAT rate...
May 26, 2009 at 10:42 pm
If you name a transaction with something like BEGIN TRANSACTION transaction_name, and trace the SQLTransaction event in Profiler, the transaction name appears in the ObjectName column. This is true...
May 26, 2009 at 3:20 pm
As far as I know, the precise details of the default sampling are undocumented, save that tables with fewer than 1,024 pages are always fully scanned. Some additional information...
May 26, 2009 at 4:29 am
Also, for ideas on efficient paging when using a custom ORDER BY clause, take a look at the following SSC article:
http://www.sqlservercentral.com/articles/Advanced+Querying/3181/
There are many similar works on the interweb, as indexed...
May 26, 2009 at 4:06 am
Viewing 15 posts - 7,876 through 7,890 (of 8,416 total)