Viewing 15 posts - 7,201 through 7,215 (of 18,923 total)
mw112009 (2/4/2011)
Hello!I am interested in shrinking the size of the backup file ( not the log file ).
Your command looks like it is going to shrink the transaction log.
The only...
February 4, 2011 at 6:29 am
Care to make one (I can't find a better match)? I think you'd explain it better than me.
Let me know either way and I'll vote for it.
February 2, 2011 at 8:30 am
Ninja's_RGR'us (2/2/2011)
Do you have a link to the connect ticket? I'm searching on sql 2008 and I'm not finding it!!
Is this the one G?
https://connect.microsoft.com/SQLServer/feedback/details/177308/enhancement-to-isnumeric
February 2, 2011 at 8:20 am
Do you have a link to the connect ticket? I'm searching on sql 2008 and I'm not finding it!!
February 2, 2011 at 8:12 am
Tx G... so I guess a small insert hit is not that big a deal after all :hehe:.
February 2, 2011 at 7:59 am
Compare both queries... you'll most likely find only 1-2 characters difference in the query and that will explain the 2 plans.
February 1, 2011 at 3:54 pm
Or plan B not using the temp table and saving some overhead.
DECLARE @tst VARCHAR(100)
SET @tst = 'fail'
SELECT 1 WHERE NOT @tst LIKE '%[^0-9]%'
SET @tst = '0123456789'
SELECT 1 WHERE NOT @tst...
February 1, 2011 at 11:49 am
Jeff Moden (2/1/2011)
Craig Farrell (1/31/2011)
dajonx (1/31/2011)
I was wondering if there is a way to remove a killed SPID that has been in rollback for a week without restarting SQL service....
February 1, 2011 at 10:34 am
I'm a total 0 in SSIS so I think I'd rather wait for your true framework.
I just opened the package and I just don't know where to start.
February 1, 2011 at 10:25 am
HowardW (2/1/2011)
Well 2 things. Either the query is wrong which is still likely at this point or you're hittinga bug. Either case upgrading the server(especially ifit's isolated can't really hurt).
I...
February 1, 2011 at 10:08 am
lindbergh_ddv (2/1/2011)
The server update status is ** SQL Server - Product version: 10.50.1600.1 - Product level:...
February 1, 2011 at 9:56 am
What patch level are you on on that server?
February 1, 2011 at 9:38 am
Do as you wish... but there's nothing more I can offer than fix the missing join.
February 1, 2011 at 9:36 am
HowardW (2/1/2011)
Are the below two objects tables or views?:
[tbl_233421d595dc4719b2429d27bf5a0399_\PreparingFactTable\CommissioniPerformance\FactTab][tbl_527741baf48446da94b7e767ed004314_\PreparingFactTable\CommissioniPerformance\FactTab]
Can you post the DDL for these if they're views?
Can't be a table. It has to be a synonym or a...
February 1, 2011 at 9:19 am
We need the basic view definitions as well.
You have 4 very serious warnings about missing join predicates that I'd take care of 1st... that may even fix it for you.
That...
February 1, 2011 at 9:18 am
Viewing 15 posts - 7,201 through 7,215 (of 18,923 total)