Viewing 15 posts - 661 through 675 (of 2,463 total)
Sean Lange (12/20/2012)
pr.price <> 9999.99
Try making this a SARGable predicate by removing the <> and replacing with > OR <
pr.price < 9999.99 OR pr.price > 9999.99
new learning for me....
December 20, 2012 at 10:55 pm
I had read the article but couldnt able to extract the pure juice thats why i added a post here to have more and clear insight.
Jeff Moden (12/20/2012)
December 20, 2012 at 10:49 pm
can you post the graphical exec plan too ? and complete tabla and index definition ?
December 20, 2012 at 5:02 am
OK thanks for explanation . can you please explain the phrase
We Added a Tempdb Data File, and Data Was Wrong
from http://www.brentozar.com/archive/2011/08/tempdb-multiplefiles-sort/
December 20, 2012 at 4:26 am
lonhanner (12/19/2012)
OK I am back. After geting my TRIP_DETAIL table created now I am having problems creating the relationships, and FK's
For PK
ALTER TABLE TRIP
ADD CONSTRAINT pk_TRIP_trip PRIMARY...
December 19, 2012 at 10:43 pm
dakshinamurthy-655138 (12/19/2012)
while adding the perfmon counters for SQL 2008 it is working but where in if a add the counters under perfmon for SQL 2005 it is not working.
Which...
December 19, 2012 at 4:01 am
xmozart.ryan (12/19/2012)
Bhuvnesh (12/18/2012)
xmozart.ryan (12/18/2012)
DECLARE @query varchar(255)
SET @query = (select t_sql from t_test)
select * from (@query)
but i got err. msg "Must declare the variable '@query'"
What yiu actually need here the...
December 19, 2012 at 12:22 am
xmozart.ryan (12/18/2012)
DECLARE @query varchar(255)
SET @query = (select t_sql from t_test)
select * from (@query)
but i got err. msg "Must declare the variable '@query'"
What yiu actually need here the query as...
December 18, 2012 at 11:22 pm
RK2012 (12/18/2012)
Can you please give me modified script
DECLARE @sql NVARCHAR(MAX)
SELECT @sql = REPLACE(
CAST(
(
SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13) + CHAR(10) +
'SELECT ' + CHAR(13) + CHAR(10) +
'DatabaseName =...
December 18, 2012 at 11:17 pm
scogeb (12/18/2012)
Anyone doing that with this product? It looks awesome on paper, but I'd like some real world feedback. Thanks!
i would say use the trial version first...
December 18, 2012 at 11:13 pm
sqlfriends (12/18/2012)
If we start web server first, then SQl server, is it going to be a problem to connect after that?
Application needs database connection first .So database server should...
December 18, 2012 at 11:11 pm
i also spend my non-working time on sqlservercentral (70% reading articles + 30% helping people). generally it takes 3-4 hours daily.
I wish my manager is not member of...
December 18, 2012 at 11:08 pm
djordan 4543 (12/18/2012)
thanks - I think I might be getting closer.. how do I check that?
--Bpool stats
select (bpool_committed * 8192)/ (1024*1024) as bpool_committed_mb
, (cast(bpool_commit_target as bigint) * 8192) / (1024*1024)...
December 18, 2012 at 11:02 pm
Jeff Moden (12/18/2012)
December 18, 2012 at 10:57 pm
lonhanner (12/18/2012)
I just need the sql query to do the sort and fill the New TD_NUM.
create table TRIP_NEW
(
TD_NUM int identity not null,
other columns list
)
insert into TRIP_NEW (columns list)
select...
December 18, 2012 at 10:53 pm
Viewing 15 posts - 661 through 675 (of 2,463 total)