Odd that you get it with the command line only tools. You're definitely getting the Winzip UI form and not just a shell screen - as far as I'm aware,...

antonyp 46888 (9/23/2010)

When i got this error,I ran following queries and DB back.

EXEC sp_resetstatus 'yourDBname';

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb('yourDBname')

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)

ALTER...

Seconded to post the statement and create table scripts - this is definitely SQL Server 2008?

Having said that, it's refreshing to get a post from someone saying their query's running too fast 😀

The optimiser is much more intelligent than that.

SQL's a declarative language, so when you use a sub query or CTE, it doesn't just take you literally, it reads the entire...

It uses SMO. These can be used programmatically through any .net language or Powershell.

Here's a good place to start:

http://msdn.microsoft.com/en-us/library/ms162169.aspx

This is also a great article that does practically what you...

You'll need to give more information than that for people to be able to properly help. Have a look here for more information:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

As a stab in the dark, I doubt...

Yep - downloaded...

Let me know if I've missed any options that you need:

USE [AdventureWorks]

GO

/****** Object: Table [Sales].[SalesOrderDetail] Script Date: 09/20/2010 14:05:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE...

In my previous post... 🙂

There you go (Same SS2k8 SP1 Quad-Core as previous post):

--===== Split8KTally mlTVF ===========================================================================================

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 0 ms.

Table...

Similar results here (on Quad Core laptop SS2K8 SP1):

(11000 row(s) affected)

93505,119866,70015,71143,24626,62589,40184,59632,38481,118972,96168,118056,1795,109516,83755,2966,13657,56092,34704,45238,36859,65379,45753,16887,34112,120845,119138,22041,74279,83754,34796,6808,57448,99588,57252,116251,3459,57143,111840,27789,9306,43152,69984,86956,103090,20651,78984,103994,49750,4216,99706,108684,104970,7768,48837,22219,36379,18951,87704,119377,38495,120803,13227,58167,103388,61873,109852,12315,17756,31004,81302,54261,22279,34523,43652,67043,2656,14668,7523,89039,1819,15905,92662,55380,61642,35440,69001,88761,109026,100653,83910,78138,56175,39300,115153,73287,58867,103401,30146,22929,111148,78761,89283,45205,28267,88940,39738,70838,34181,72573,74317,53090,103229,68089,120804,70965,63660,58484,62077,40720,78515,49156,12166,108634,58902,84864,48113,74813,17686,26688,45200,13848,71295,110993,108735,39060,100429,34773,49710,514,50029,99672,87908,95850,69608,20017,47768,66719,34255,80490,76102,113501,114636,45012,73598,40816,101330,23720,8585,29180,101994,111028,117842,13643,17374,70470,43040,61723,71675,26311,59288,118734,107933,9291,29532,65992,41254,38194,88399,103982,75317,112826,104399,109436,9674,1744,77216,43980,28337,74047,29505,78592,92615,63417,46301,8348,26793,44853,35322,106834,77870,15084,82373,9743,16755,11046,22871,39033,108282,71022,38614,41937,92730,57515,93913,33194,24815,94997,65920,26764,58900,120109,113374,81338,88301,73308,85284,104272,42101,117046,113409,58940,2183,73455,48917,62185,26033,51183,32359,51301,83936,6697,90039,93948,16533,15432,4366,16093,70918,330,63036,46041,1970,16165,17083,119929,61799,10509,63384,44498,103265,29786,45782,16313,110622,107622,50402,5417,101783,73682,26066,58114,11869,108378,24573,78397,96209,58942,84767,119284,98252,61683,84690,64959,35649,62914,103553,82067,110531,116935,7086,109757,1956,63063,33163,98632,30236,35203,74341,51552,35485,49080,17190,114811,54193,72382,9446,47631,93415,36195,115965,29750,102307,21760,44295,56725,36201,66518,41917,49412,14373,76560,46946,114449,49261,67914,75163,25036,82033,30037,65455,10039,1233,111266,6510,112531,63593,51449,9384,46049,106440,90308,97497,83817,94695,90893,58800,112045,106194,73321,115483,39791,30526,91720,114369,35278,54289,85914,43453,3064,82524,16947,34101,35472,76253,24736,46471,32012,27314,23925,98604,101638,67464,85997,110012,11713,101618,96727,11835,120466,91405,104954,62934,884,43690,43407,76061,346,101846,93251,84265,83075,23557,69713,7386,85889,39087,12320,105535,112058,87007,12963,21319,94335,61282,15347,119909,49439,56106,118954,87497,45384,28606,78721,102117,6681,119153,14486,51953,98518,6189,33062,43400,118509,100285,14467,110037,37860,24916,61870,13886,117234,102306,62286,32109,114870,8786,21167,101111,119204,48573,27023,50601,39210,117846,67323,25030,117147,47312,68204,91539,9656,93402,30173,43122,54541,63792,90684,112169,96694,87446,120256,29667,71773,64341,110558,3195,96714,102923,45596,72423,59622,29896,121259,80528,28203,16312,50253,54531,29562,65904,97937,98450,46821,100872,27534,76221,51932,83293,40676,84609,111564,794,31750,83511,93267,94154,23603,51973,41449,8798,60876,59537,36127,18211,89544,66920,12297,107993,65069,1706,2505,118718,114613,58863,97763,60335,62611,111389,18709,64420,68987,13491,5591,112705,12133,117678,32802,14496,61079,83931,29218,26041,118141,50752,107019,99586,23476,9299,16806,84492,5257,4228,82458,107236,85656,43148,59979,31297,69676,28672,12572,10286,64731,70745,90813,91101,13808,60446,75437,120439,20500,7895,107878,72589,77358,111325,42589,74568,97577,119083,17835,94852,67572,85161,63734,59970,8869,70552,116627,113715,102425,42207,8503,113537,21018,30197,118457,45371,93838,58873,7620,51406,6590,103706,35968,57457,12115,53612,54238,68016,74256,27475,23853,9714,9451,6289,20647,15833,98085,111900,25469,42652,75314,26072,78051,13607,89758,10612,38206,12101,100973,15170,63748,10532,19489,77975,34928,47571,91317,41054,22750,45063,17839,10410,68183,105837,35435,42458,628,69953,104133,57656,35952,54059,38842,80009,52446,61432,40012,94369,80747,77156,14141,49703,44767,46028,6721,47619,54067,13798,114736,64623,20397,104077,13761,89908,4392,8978,54731,47106,69093,3786,89423,18828,77620,3128,93826,38244,29688,57893,46510,80180,34487,84514,43104,31906,77212,54613,65099,70988,116575,64382,69007,2839,20602,14159,98603,118221,58547,55375,20293,107771,115030,11022,112892,45178,33380,39253,75835,64427,89392,19046,62207,71163,65627,108476,101911,93218,47005,61664,7900,40367,24433,25760,64035,70329,27643,42913,107356,36597,82055,46543,4033,107785,21729,23963,99060,62425,108430,38485,43592,36599,74737,78012,18977,62276,36641,88675,77660,58052,36748,102724,9030,52866,40752,44828,107321,64782,95809,115245,2909,35462,108263,56893,49604,114832,95136,70802,55331,33367,96104,23691,6802,101965,96915,44265,47327,26801,119449,86035,99022,98780,99225,53718,11090,18779,51891,86373,79982,54845,102756,93602,99802,101164,95680,119070,18094,79160,27817,25813,84565,16106,27655,7872,41644,94034,60755,83194,5630,101628,42801,81484,23145,16817,83727,74144,100330,59809,55280,115858,3228,14130,112121,101565,60074,1974,30838,9876,109789,82057,6813,51657,112661,19657,98841,58094,53050,83232,6454,12742,58141,59795,1055,21333,59894,85560,77254,64118,83835,49068,4412,51750,31830,79478,12378,51453,101436,12702,17217,83578,10006,73547,75159,92789,29885,43054,25958,39982,83381,22437,43999,22135,11056,65149,106475,110608,89883,3209,15695,32040,109352,115460,115734,45234,92382,22782,24696,105235,55832,95729,64468,57078,84430,101249,69068,14170,63969,96779,49254,85806,73789,74029,604,118728,63138,18213,98613,94544,101615,108844,41894,15539,36430,41648,110579,16785,53472,33544,102221,56781,43354,69222,62922,98790,70250,15650,21510,43468,59402,105138,109294,95289,114552,6625,77897,31162,112465,93283,43253,7376,119714,3358,16431,7186,53409,17062,77060,90387,72479,3861,113316,97346,109368,13528,49636,35833,83512,45510,31151,14828,103530,3407,11951,1978,43464,72435,48504,84413,25687,97059,46820,117747,101542,116146,206,76909,17759,110042,38433,4742,51523,82801,14555,83437,52012,53558,66184,54163,64476,93243,57701,25016,44480,104059,12212,74491,78837,34298,72628

--===== Split8KTally ===========================================================================================

SQL Server Execution Times:

CPU time = 0 ms, elapsed time = 4 ms.

Table...

While that will work, it's not efficient. The entire case statement is unnecessary anyway (see my example above).

I would recommend reading up on catch all query performance even though...

I think you're getting confused about what Case does. The purpose is to return a different result based on the which case condition is true, you're testing whether one condition...

Just a general point, you should be careful using a uniqueidentifier as part of a Clustered Index. Due to the random nature of Unique Identifiers, you can end up with...