Viewing 15 posts - 496 through 510 (of 1,162 total)
GilaMonster (2/27/2012)
February 27, 2012 at 5:42 am
Jeff Moden (2/25/2012)
HowardW (2/24/2012)
Artoo22 (2/24/2012)
SELECT*FROM#t
WHEREDateCreated >= ISNULL(@FromDate, DateCreated)
ANDDateCreated <= ISNULL(@ThroughDate, DateCreated)
It might look neater, but the use of scalar functions (ISNULL) guarantees that indexes can't be used to fulfil the...
February 27, 2012 at 5:21 am
Not sure I quite followed you, but looking at the query you've written, is this all you're after:
SELECT STRT.prog ,
STRT.ordno AS...
February 24, 2012 at 10:28 am
I think given the nature of the product, they're pretty much assuming everyone will be using a 64-bit O/S with it.
Remember, Virtual Address Space and RAM are two different...
February 24, 2012 at 10:17 am
I suspect this is a Virtual Address Space issue. The Tabular Model sounds like it's built on a similar premise to PowerPivot and this is limited to 2GB of address...
February 24, 2012 at 10:04 am
I'm not an expert on the encryption in SQL Server, but from looking at the BOL article on column encryption, there's no such thing.
It's simply a varbinary column that...
February 24, 2012 at 9:32 am
It's a check that only returns the distinct Regions in #Import that don't exist in Fireball.dbo.Region. E.g. This pattern would be common in the select for an INSERT into Fireball.dbo.Region,...
February 24, 2012 at 8:18 am
Easy enough. Just open the master package, go to SSIS->Logging... then create an SSIS Logging Provider for Text Files. In the details, just select OnError and OnWarning and they'll automatically...
February 24, 2012 at 5:09 am
If the service starts ok manually and the logon trigger is doing something that's complicated/dependent on another windows service that's in the process of coming up when the server gets...
February 24, 2012 at 4:55 am
Cadavre (2/24/2012)
February 24, 2012 at 3:00 am
Artoo22 (2/24/2012)
SELECT*FROM#t
WHEREDateCreated >= ISNULL(@FromDate, DateCreated)
ANDDateCreated <= ISNULL(@ThroughDate, DateCreated)
It might look neater, but the use of scalar functions (ISNULL) guarantees that indexes can't be used to fulfil the query.
February 24, 2012 at 2:35 am
This is a classic Catch-All query.
Gail's post here[/url] summarises the different options well.
The construct you've posted above could be very bad for performance prior to SQL 2008 SP2, but you...
February 24, 2012 at 2:18 am
Steve Jones - SSC Editor (2/23/2012)
HowardW (2/23/2012)
Looking forward to some of the BI sessions as I haven't spent enough time delving...
February 23, 2012 at 10:40 am
Is anyone here going to SQLBits X in London?
Looking forward to some of the BI sessions as I haven't spent enough time delving into 2012 yet.
Are there any...
February 23, 2012 at 10:01 am
http://en.wikipedia.org/wiki/Transact-SQL
Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. SQL, often expanded to Structured Query Language, is a standardized computer language that was originally developed by IBM for querying,...
February 22, 2012 at 9:02 am
Viewing 15 posts - 496 through 510 (of 1,162 total)