Viewing 15 posts - 19,126 through 19,140 (of 19,564 total)
This is a common occurrence in SSIS. Even if the isSorted property is set and the SortOrder defined in your source, merge joins sometimes ignore them. For the...
November 16, 2009 at 12:38 pm
Bru Medishetty (11/16/2009)
Use This
SELECT TOP 2 AppName, Date, Query FROM YOUR_TABLEGROUP BY AppName, Date, Query
I think this is more like what you are seeking
With toptwo as (SELECT AppName, Date, Query,row_number()...
November 16, 2009 at 12:15 pm
GSquared (11/16/2009)
Jeffrey Williams-493691 (11/16/2009)
GSquared (11/16/2009)
If it has multiple peanuts, it's clustered. If it's just one peanut per database, then it's not. Seems simple to me.
What if you have...
November 16, 2009 at 11:56 am
halifaxdal (11/16/2009)
I have an asp.net web application, I need to connect to another department to retrieve data there, it's a SQL database (not sure if it is 2k5 or...
November 16, 2009 at 11:46 am
GSquared (11/16/2009)
GilaMonster (11/16/2009)
Looks like someone needs a basic computer theory course.Clustering: http://www.sqlservercentral.com/Forums/Topic819325-146-1.aspx
SAN: http://www.sqlservercentral.com/Forums/Topic819323-146-1.aspx
RAID: http://www.sqlservercentral.com/Forums/Topic819327-146-1.aspx
I would like to apologize for my answers to all three of those... but I won't. 😀
I...
November 16, 2009 at 11:40 am
or does the singular just correlate to with (without the out since without is plural)?
What does that make of the SANS Institute?
Just pondering...
Seriously though - check with your server admin...
November 16, 2009 at 11:39 am
Lynn Pettis (11/16/2009)
CirquedeSQLeil (11/16/2009)
Lynn Pettis (11/16/2009)
November 16, 2009 at 11:36 am
Lynn Pettis (11/16/2009)
November 16, 2009 at 9:51 am
Lynn Pettis (11/14/2009)
Want to talk about broken records?
Spot ON. I kind of think of it as an incoherent rambling soap-box.
November 14, 2009 at 8:32 pm
I have to agree with Lynn and Flo on this one. As much as it might be nice to code generically so the code will perform on all DBMS's,...
November 14, 2009 at 8:31 pm
I think it largely depends on your company.
Many places they are one and the same. The DBA designs the databse, supports production, and reviews code.
Some places they distinguish between...
November 14, 2009 at 8:10 pm
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD' WITH ('ONLINE = ON') ;
Should be
SET @command = N'ALTER...
November 13, 2009 at 3:33 pm
IF @frag >= 30.0
SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD';
In the above script you would add
...
November 13, 2009 at 2:44 pm
Viewing 15 posts - 19,126 through 19,140 (of 19,564 total)