Showing posts with label SQL 2005. Show all posts
Showing posts with label SQL 2005. Show all posts

Thursday, June 3, 2010

Tools - Series one more

Free software


Paid for software
Visual Studio 2008 Pro (however code should be usable by VS2008 express versions)
SQL2005/2008 Developer Edition (however TSQL should be usable by express versions)
ReSharper.Com http://www.jetbrains.com/resharper/download/ was used to optimise the code.
Vipre from http://www.sunbelt-software.com - an excellent anti-virus and anti-spyware program.
Posted by at No comments:
Labels: , , ,

Friday, April 23, 2010

SQL Backup database - plan using same file name

How to SQL backup database, using scheduled maintenance plans to overwrite the same file name every time the backup is processed?

Solution:

Create a maintenance plan with t-sql in the job step similar to:

exec master.dbo.xp_backup_database @database = '', @filename = 'E:\Backup\_Daily.Bak', @backupname = ' backup', @desc = 'Backup of daily', @logging = 0, @with = 'SKIP', @init= 1, @with = 'STATS = 10'

Note, if the files with same name are overwriting with each backup, there will never be more than one archived backup on that destination.

Posted by at No comments:
Labels:

Thursday, April 8, 2010

Example of With Rollup and With Cube in SQL 2005

Cool: Technique with Rollup and with cube in SQL 2005.

Declare @TempTableData table
(
Customer varchar(50),
ItemName varchar(50),
Quantity int,
PricePerItem float
);

Insert into @TempTableData
Select 'Sreedhar', 'Item 1', 2, 60.00 Union all
Select 'Sreedhar', 'Item 2', 2, 40.00 Union all
Select 'Vankayala', 'Item 1', 1, 60.00 Union all
Select 'Vankayala', 'Item 2', 1, 40.00 Union all
Select 'Vankayala', 'Item 3', 1, 10.00

-- Select all from table
Select * from @TempTableData;

-- Select all with calculated price
SELECT Customer, ItemName, SUM(Quantity * PricePerItem) as Price
FROM @TempTableData
GROUP BY Customer, ItemName

-- Select all with calculated price (with ROLLUP)
SELECT
Case when grouping(Customer) = 1 then 'All Customers' else Customer end as Customer,
Case when grouping(ItemName) = 1 then 'All Items' else ItemName end as ItemName,
SUM(Quantity * PricePerItem) as Price
FROM @TempTableData
GROUP BY Customer, ItemName
With ROLLUP

-- Select all with calculated price (with CUBE)
SELECT
Case when grouping(Customer) = 1 then 'All Customers' else Customer end as Customer,
Case when grouping(ItemName) = 1 then 'All Items' else ItemName end as ItemName,
SUM(Quantity * PricePerItem) as Price
FROM @TempTableData
GROUP BY Customer, ItemName
With CUBE


Results for the above SQL:

Customer ItemName Quantity PricePerItem
Sreedhar Item 1 2 60
Sreedhar Item 2 2 40
Vankayala Item 1 1 60
Vankayala Item 2 1 40
Vankayala Item 3 1 10

(5 row(s) affected)

Customer ItemName Price
Sreedhar Item 1 120
Vankayala Item 1 60
Sreedhar Item 2 80
Vankayala Item 2 40
Vankayala Item 3 10

(5 row(s) affected)

Customer ItemName Price
Sreedhar Item 1 120
Sreedhar Item 2 80
Sreedhar All Items 200
Vankayala Item 1 60
Vankayala Item 2 40
Vankayala Item 3 10
Vankayala All Items 110
All Customers All Items 310

(8 row(s) affected)


Customer ItemName Price
Sreedhar Item 1 120
Sreedhar Item 2 80
Sreedhar All Items 200
Vankayala Item 1 60
Vankayala Item 2 40
Vankayala Item 3 10
Vankayala All Items 110
All Customers All Items 310
All Customers Item 1 180
All Customers Item 2 120
All Customers Item 3 10

(11 row(s) affected)
Posted by at No comments:
Labels: ,

Thursday, February 11, 2010

SQL Server Complete Version list


Scroll to the end of this post for the source copied ...



VersionBuildDescription
10.0.27342734SQL Server 2008 + Cumulative Update 4 for SP1
10.0.27232723SQL Server 2008 +Cumulative Update 3 for SP1
10.0.27142714SQL Server 2008 + Cumulative Update 2 for SP1
10.0.27122712SQL Server 2008 + Q970507
10.0.27102710SQL Server 2008 + Cumulative Update 1 for SP1
10.0.25312531SQL Server 2008 + Service Pack 1
10.0.18121812SQL Server 2008 + Cumulative Update 6
10.0.17981798SQL Server 2008 + Cumulative Update 4
10.0.17871787SQL Server 2008 + Cumulative Update 3
10.0.17791779SQL Server 2008+Q958186 (Cumulative HF2, available byrequest.)
10.0.17711771SQL Server 2008+Q958611
10.0.17501750SQL Server 2008+Q956718
10.0.1600.221600SQL Server 2008 RTM
10.0.1300.131300SQL Server 2008 February CTP
10.0.1049.141049SQL Server 2008 July CTP (requires Virtual Server 2005 R2)
10.0.1019.171019SQL Server 2008 June CTP
9.00.42304230SQL Server 2005 SP3 + Q972511 (Cumulative Hot Fix 5)
9.00.42264226SQL Server 2005 SP3+Q970279 (Cumulative HF 4)
9.00.42244224SQL Server 2005 + Q971409
9.00.42204220SQL Server 2005 SP3+Q967909 (Cumulative HF3)
9.00.42164216SQL Server 2005 SP3+Q967101
9.00.42114211SQL Server 2005 SP3+Q961930 (Cumulative HF2)
9.00.42074207SQL Server 2005 SP3+Q959195 (Cumulative HF1)
9.00.40534053SQL Server 2005 SP3 + Q970892 (MS09-062)
9.00.40354035SQL Server 2005+SP3 (Q955706)
9.00.33283328SQL Server 2005 SP2+Q970278 (Cumulative HF14)
9.00.33273327SQL Server 2005 SP2+Q948567 / 961648
9.00.33253325SQL Server 2005 SP2+Q967908 (Cumulative HF 13)
9.00.33203320SQL Server 2005 SP2+Q969142
9.00.33153315SQL Server 2005 SP2+Q962970 (Cumulative HF12, available viarequest.)
9.00.33103310SQL Server 2005 SP2+Q960090
9.00.33033303SQL Server 2005 SP2+Q962209
9.00.33023302SQL Server 2005 SP2+Q961479 / 961648
9.00.33013301SQL Server 2005 SP2+Q958735 (Cumulative HF11, avail. viarequest.)
9.00.32953295SQL Server 2005 SP2+Q959132
9.00.32943294SQL Server 2005 SP2+Q956854 (Cumulative HF10, avail. viarequest.)
9.00.32913291SQL Server 2005 SP2+Q956889
9.00.32893289SQL Server 2005 SP2+Q937137
9.00.32823282SQL Server 2005 SP2+Q953752 / 953607 (Cumulative HF9, avail. via request or by clicking here.)
9.00.32613261SQL Server 2005 SP2+Q955754
9.00.32603260SQL Server 2005 SP2+Q954950
9.00.32593259SQL Server 2005 SP2+Q954669 / 954831
9.00.32573257SQL Server 2005 SP2+Q951217 (Cumulative HF8, avail. viarequest.)
9.00.32533253SQL Server 2005 SP2+Q954054
9.00.32443244SQL Server 2005 SP2+Q952330
9.00.32423242SQL Server 2005 SP2+Q951190
9.00.32403240SQL Server 2005 SP2+Q951204
9.00.32393239SQL Server 2005 SP2+Q949095 (Cumulative HF7, avail. via PSS only - must supply KBID of issue to resolve in your request)
9.00.32353235SQL Server 2005 SP2+Q950189
9.00.32333233SQL Server 2005 (QFE) SP2+Q941203 / 948108
9.00.32323232SQL Server 2005 SP2+Q949959
9.00.32313231SQL Server 2005 SP2+Q949687/949595
9.00.32303230SQL Server 2005 SP2+Q949199
9.00.32283228SQL Server 2005 SP2+Q946608 (Cumulative HF6, avail. via PSS only - must supply KBID of issue to resolve in your request)
9.00.32243224SQL Server 2005 SP2+Q947463
9.00.32223222SQL Server 2005 SP2+Q945640 / 945641 / 947196 / 947197
9.00.32213221SQL Server 2005 SP2+Q942908 / 945442 / 945443 / 945916 /944358
9.00.32153215SQL Server 2005 SP2+Q941450 (Cumulative HF5, avail. via PSS only - must supply KBID of issue to resolve in your request)
9.00.32093209SQL Server 2005 SP2 (KB N/A, SQLHF Bug #50002118)
9.00.32083208SQL Server 2005 SP2+Q944902
9.00.32063206SQL Server 2005 SP2+Q944677
9.00.32053205SQL Server 2005 SP2 (KB N/A, SQLHF Bug #50001708/50001999)
9.00.32033203SQL Server 2005 SP2 (KB N/A, SQLHF Bug #50001951/50001993/50001997/50001998/50002000)
9.00.32003200SQL Server 2005 SP2+Q941450 (Cumulative HF4, avail. via PSS only - must supply KBID of issue to resolve in your request)
9.00.31953195SQL Server 2005 SP2 (KB N/A, SQLHF Bug #50001812)
9.00.31943194SQL Server 2005 SP2+Q940933
9.00.31863186SQL Server 2005 SP2+Q939562 (Cumulative HF3, avail. via PSS only - must supply KBID of issue to resolve in your request)
9.00.31823182SQL Server 2005 SP2+Q940128
9.00.31803180SQL Server 2005 SP2+Q939942
9.00.31793179SQL Server 2005 SP2+Q938243
9.00.31783178SQL Server 2005 SP2 (KB N/A, SQLHF Bug #50001193/5001352)
9.00.31773177SQL Server 2005 SP2+Q939563 / 939285
9.00.31753175SQL Server 2005 SP2+Q936305 /938825 (Cumulative HF2, avail. via PSS only - must supply KBID of issue to resolve in your request)
9.00.31713171SQL Server 2005 SP2+Q937745
9.00.31693169SQL Server 2005 SP2+Q937041/937033
9.00.31663166SQL Server 2005 SP2+Q936185 / 934734
9.00.31623162SQL Server 2005 SP2+Q932610/935360/935922
9.00.31613161SQL Server 2005 SP2+Q935356/933724(Cumulative HF1, avail. via PSS only - must supply KBID of issue to resolve in your request)
9.00.31593159SQL Server 2005 SP2+Q934459
9.00.31563156SQL Server 2005 SP2+Q934226
9.00.31553155SQL Server 2005 SP2+Q933549 /933766/933808/933724/932115/933499
9.00.31543154SQL Server 2005 SP2+Q934106 / 934109 / 934188
9.00.31533153SQL Server 2005 SP2+Q933564
9.00.31523152SQL Server 2005 SP2+Q933097 (Cumulative HF1)
9.00.30773077SQL Server 2005 SP2+Q960089
9.00.30733073SQL Server 2005 SP2+Q954606 (GDR)
9.00.30683068SQL Server 2005 (GDR) SP2+Q941203 / 948109
9.00.30543054SQL Server 2005 SP2+Q934458
9.00.30503050SQL Server 2005 SP2+Q933508
9.00.30433043SQL Server 2005 SP2+Q933508 (use this if SP2 was applied prior to 3/8)
9.00.30423042SQL Server 2005 'Fixed' SP2 (use this if SP2 was NOT applied yet - orig. RTM removed)
9.00.30333033SQL Server 2005 SP2 CTP (December) - Fix List
9.00.30273027SQL Server 2005 SP2 CTP (November)
9.00.30263026SQL Server 2005 SP1+Q929376
9.00.22492249SQL Server 2005 SP1+Q948344
9.00.22452245SQL Server 2005 SP1+Q933573
9.00.22432243SQL Server 2005 SP1+Q944968
9.00.22422242SQL Server 2005 SP1+Q943389/943388
9.00.22392239SQL Server 2005 SP1+Q940961
9.00.22372237SQL Server 2005 SP1+Q940719
9.00.22362236SQL Server 2005 SP1+Q940287 / 940286
9.00.22342234SQL Server 2005 SP1+Q937343
9.00.22332233SQL Server 2005 SP1+Q933499/937545
9.00.22322232SQL Server 2005 SP1+Q937277
9.00.22312231SQL Server 2005 SP1+Q934812
9.00.22302230SQL Server 2005 SP1+Q936179
9.00.22292229SQL Server 2005 SP1+Q935446
9.00.22272227SQL Server 2005 SP1+Q934066/933265
9.00.22262226SQL Server 2005 SP1+Q933762/934065934065
9.00.22242224SQL Server 2005 SP1+Q932990 / 933519
9.00.22232223SQL Server 2005 SP1+Q932393
9.00.22212221SQL Server 2005 SP1+Q931593
9.00.22192219SQL Server 2005 SP1+Q931329 / 932115
9.00.22182218SQL Server 2005 SP1+Q931843 / 931843
9.00.22162216SQL Server 2005 SP1+Q931821
9.00.22152215SQL Server 2005 SP1+Q931666
9.00.22142214SQL Server 2005 SP1+Q929240 / 930505 / 930775
9.00.22112211SQL Server 2005 SP1+Q930283 / 930284
9.00.22092209SQL Server 2005 SP1+Q929278
9.00.22082208SQL Server 2005 SP1+Q929179 / 929404
9.00.22072207SQL Server 2005 SP1+Q928394 / 928372 / 928789
9.00.22062206SQL Server 2005 SP1+Q928539 / 928083 / 928537
9.00.22022202SQL Server 2005 SP1+Q927643
9.00.22012201SQL Server 2005 SP1+Q927289
9.00.21982198SQL Server 2005 SP1+Q926773 / 926611 / 924808 / 925277 /926612 / 924807 / 924686
9.00.21962196SQL Server 2005 SP1+Q926285/926335/926024
9.00.21952195SQL Server 2005 SP1+Q926240
9.00.21942194SQL Server 2005 SP1+Q925744
9.00.21922192SQL Server 2005 SP1+Q924954/925335
9.00.21912191SQL Server 2005 SP1+Q925135
9.00.21902190SQL Server 2005 SP1+Q925227
9.00.21892189SQL Server 2005 SP1+Q925153
9.00.21872187SQL Server 2005 SP1+Q923849
9.00.21832183SQL Server 2005 SP1+Q929404 / 924291
9.00.21812181SQL Server 2005 SP1+Q923624/923605
9.00.21762176SQL Server 2005 SP1+Q923296 / 922594
9.00.21752175SQL Server 2005 SP1+Q922578 /922438 / 921536 / 922579 /920794
9.00.21742174SQL Server 2005 SP1+Q922063
9.00.21672167SQL Server 2005 SP1+Q920974/921295
9.00.21642164SQL Server 2005 SP1+Q919636 / 918832/919775
9.00.21562156SQL Server 2005 SP1+Q919611
9.00.21532153SQL Server 2005 SP1+builds 1531-40 (See Q919224 before applying!)
9.00.20502050SQL Server 2005 SP1+.NET Vulnerability fix
9.00.20472047SQL Server 2005 SP1 RTM
9.00.20402040SQL Server 2005 SP1 CTP
9.00.20292029SQL Server SP1 Beta
9.00.15611561SQL Server 2005 RTM+Q932556
9.00.15581558SQL Server 2005 RTM+Q926493
9.00.15541554SQL Server 2005 RTM+Q926292
9.00.15511551SQL Server 2005 RTM+Q922804
9.00.15501550SQL Server 2005 RTM+Q917887/921106
9.00.15471547SQL Server 2005 RTM+Q918276
9.00.15451545SQL Server 2005 RTM+Q917905/919193
9.00.15411541SQL Server 2005 RTM+Q917888/917971
9.00.15391539SQL Server 2005 RTM+Q917738
9.00.15381538SQL Server 2005 RTM+Q917824
9.00.15361536SQL Server 2005 RTM+Q917016
9.00.15341534SQL Server 2005 RTM+Q916706
9.00.15331533SQL Server 2005 RTM+Q916086
9.00.15321532SQL Server 2005 RTM+Q916046
9.00.15311531SQL Server 2005 RTM+Q915918
9.00.15281528SQL Server 2005 RTM+Q915112 / 915306 / 915307/ 915308
9.00.15191519SQL Server 2005 RTM+Q913494
9.00.15181518SQL Server 2005 RTM+Q912472/913371/913941
9.00.15141514SQL Server 2005 RTM+Q912471
9.00.15031503SQL Server 2005 RTM+Q911662
9.00.15021502SQL Server 2005 RTM+Q915793
9.00.15001500SQL Server 2005 RTM+Q910416
9.00.14061406SQL Server 2005 RTM+Q932557
9.00.13991399SQL Server 2005 RTM
9.00.13141314SQL Server 2005 September CTP Release
9.00.11871187SQL Server 2005 June CTP Release
9.00.11161116SQL Server 2005 April CTP Release
9.00.10901090SQL Server 2005 March CTP Release (may list as Feb.)
9.00.981981SQL Server 2005 December CTP Release
9.00.951951SQL Server 2005 October CTP Release
9.00.917917SQL Server 2005 Internal build (?)
9.00.852852SQL Server 2005 Beta 2
9.00.849849SQL Server 2005 Internal build (?)
9.00.844844SQL Server 2005 Internal build (?)
9.00.836836SQL Server 2005 Express Ed. Tech Preview
9.00.823823SQL Server 2005 Internal build (IDW4)
9.00.790790SQL Server 2005 Internal build (IDW3)
9.00.767767SQL Server 2005 Internal build (IDW2)
9.00.747747SQL Server 2005 Internal build (IDW)
9.00.645645SQL Server 2005 MS Internal (?)
9.00.608608SQL Server 2005 Beta 1
8.0.22832283SQL Server 2000 + Q971524
8.0.22732273SQL Server 2000 (QFE) SP4+Q941203 / 948111
8.0.22712271SQL Server 2000 SP4+Q946584
8.0.22652265SQL Server 2000 SP4+Q944985
8.0.22532253SQL Server 2000 SP4+Q939317
8.0.22492249SQL Server 2000 SP4+Q936232
8.0.22482248SQL Server 2000 SP4+Q935950
8.0.22462246SQL Server 2000 SP4+Q935465
8.0.22452245SQL Server 2000 SP4+Q933573
8.0.22442244SQL Server 2000 SP4+Q934203
8.0.22422242SQL Server 2000 SP4+Q929131/932686/932674
8.0.22382238SQL Server 2000 SP4+Q931932
8.0.22342234SQL Server 2000 SP4+Q929440 / 929131
8.0.22322232SQL Server 2000 SP4+Q928568
8.0.22312231SQL Server 2000 SP4+Q928079
8.0.22292229SQL Server 2000 SP4+Q927186
8.0.22262226SQL Server 2000 SP4+Q925684/925732
8.0.22232223SQL Server 2000 SP4+Q925678 / 925419
8.0.22182218SQL Server 2000 SP4+Q925297
8.0.22172217SQL Server 2000 SP4+Q924664
8.0.22152215SQL Server 2000 SP4+Q924662/923563/923327 / 923796
8.0.22092209SQL Server 2000 SP4+Q923797
8.0.22072207SQL Server 2000 SP4+Q923344
8.0.22012201SQL Server 2000 SP4+Q920930
8.0.21992199SQL Server 2000 SP4+Q919221
8.0.21972197SQL Server 2000 SP4+Q919133/919068/919399
8.0.21962196SQL Server 2000 SP4+Q919165
8.0.21942194SQL Server 2000 SP4+Q917972 / 917565
8.0.21922192SQL Server 2000 SP4+Q917606
8.0.21912191SQL Server 2000 SP4+Q916698/916950
8.0.21892189SQL Server 2000 SP4+Q916652/913438
8.0.21872187SQL Server 2000 SP4+916287/914384/898709/915065/915340
8.0.21802180SQL Server 2000 SP4+Q913684 (64bit)
8.0.21752175SQL Server 2000 SP4+Q911678 / 922579
8.0.21722172SQL Server 2000 SP4+Q910707
8.0.21712171SQL Server 2000 SP4+Q909369
8.0.21682168SQL Server 2000 SP4+Q907813
8.0.21672167SQL Server 2000 SP4+Q921293
8.0.21662166SQL Server 2000 SP4+Q909734
8.0.21622162SQL Server 2000 SP4+Q904660
8.0.21592159SQL Server 2000 (64b) SP4+Q907250
8.0.21562156SQL Server 2000 SP4+Q906790
8.0.21512151SQL Server 2000 SP4+Q903742 / 904244
8.0.21482148SQL Server 2000 SP4+Q899430/31/900390/404/901212/902150/955
8.0.21472147SQL Server 2000 SP4+Q899410
8.0.21452145SQL Server 2000 SP4+Q826906/836651
8.0.20502050SQL Server 2000 (GDR) SP4+Q941203 / 948110
8.0.20402040SQL Server 2000 SP4+Q899761
8.0.20392039SQL Server 2000 SP4
8.0.20262026SQL Server 2000 SP4 Beta
8.0.15471547SQL Server 2000 SP3+Q899410
8.0.10371037SQL Server 2000 SP3+Q930484
8.0.10361036SQL Server 2000 SP3+Q929410
8.0.10351035SQL Server 2000 SP3+Q917593
8.0.10341034SQL Server 2000 SP3+Q915328
8.0.10291029SQL Server 2000 SP3+Q902852
8.0.10271027SQL Server 2000 SP3+Q900416
8.0.10251025SQL Server 2000 SP3+Q899428/899430
8.0.10241024SQL Server 2000 SP3+Q898709
8.0.10211021SQL Server 2000 SP3+Q887700
8.0.10201020SQL Server 2000 SP3+Q896985
8.0.10191019SQL Server 2000 SP3+Q897572
8.0.10171017SQL Server 2000 SP3+Q896425
8.0.10141014SQL Server 2000 SP3+Q895123/187
8.0.10131013SQL Server 2000 SP3+Q891866
8.0.10091009SQL Server 2000 SP3+Q894257
8.0.10071007SQL Server 2000 SP3+Q893312
8.0.10031003SQL Server 2000 SP3+Q892923
8.0.10011001SQL Server 2000 SP3+Q892205
8.0.10001000SQL Server 2000 SP3+Q891585
8.0.997997SQL Server 2000 SP3+Q891311
8.0.996996SQL Server 2000 SP3+Q891017/891268
8.0.994994SQL Server 2000 SP3+Q890942/768/767
8.0.993993SQL Server 2000 SP3+Q890925/888444/890742
8.0.991991SQL Server 2000 SP3+Q889314
8.0.990990SQL Server 2000 SP3+Q890200
8.0.988988SQL Server 2000 SP3+Q889166
8.0.985985SQL Server 2000 SP3+Q889239
8.0.980980SQL Server 2000 SP3+Q887974
8.0.977977SQL Server 2000 SP3+Q888007
8.0.973973SQL Server 2000 SP3+Q884554
8.0.972972SQL Server 2000 SP3+Q885290
8.0.970970SQL Server 2000 SP3+Q872842
8.0.967967SQL Server 2000 SP3+Q878501
8.0.962962SQL Server 2000 SP3+Q883415
8.0.961961SQL Server 2000 SP3+Q873446
8.0.959959SQL Server 2000 SP3+Q878500
8.0.957957SQL Server 2000 SP3+Q870994
8.0.955955SQL Server 2000 SP3+Q867798
8.0.954954SQL Server 2000 SP3+Q843282
8.0.952952SQL Server 2000 SP3+Q867878/867879/867880
8.0.949949SQL Server 2000 SP3+Q843266
8.0.948948SQL Server 2000 SP3+Q843263
8.0.944944SQL Server 2000 SP3+Q839280
8.0.937937SQL Server 2000 SP3+Q841776
8.0.936936SQL Server 2000 SP3+Q841627
8.0.935935SQL Server 2000 SP3+Q841401
8.0.934934SQL Server 2000 SP3+Q841404
8.0.933933SQL Server 2000 SP3+Q840856
8.0.929929SQL Server 2000 SP3+Q839529
8.0.928928SQL Server 2000 SP3+Q839589
8.0.927927SQL Server 2000 SP3+Q839688
8.0.926926SQL Server 2000 SP3+Q839523
8.0.923923SQL Server 2000 SP3+Q838460
8.0.922922SQL Server 2000 SP3+Q837970
8.0.919919SQL Server 2000 SP3+Q837957
8.0.916916SQL Server 2000 SP3+Q317989
8.0.915915SQL Server 2000 SP3+Q837401
8.0.913913SQL Server 2000 SP3+Q836651
8.0.911911SQL Server 2000 SP3+Q837957
8.0.910910SQL Server 2000 SP3+Q834798
8.0.908908SQL Server 2000 SP3+Q834290
8.0.904904SQL Server 2000 SP3+Q834453
8.0.892892SQL Server 2000 SP3+Q833710
8.0.891891SQL Server 2000 SP3+Q836141
8.0.879879SQL Server 2000 SP3+Q832977
8.0.878878SQL Server 2000 SP3+Q831950
8.0.876876SQL Server 2000 SP3+Q830912/831997/831999
8.0.873873SQL Server 2000 SP3+Q830887
8.0.871871SQL Server 2000 SP3+Q830767/830860
8.0.870870SQL Server 2000 SP3+Q830262
8.0.869869SQL Server 2000 SP3+Q830588
8.0.867867SQL Server 2000 SP3+Q830366
8.0.866866SQL Server 2000 SP3+Q830366
8.0.865865SQL Server 2000 SP3+Q830395/828945
8.0.863863SQL Server 2000 SP3+Q829205/829444
8.0.859859SQL Server 2000 SP3+Q821334 *May contain errors*
8.0.858858SQL Server 2000 SP3+Q828637
8.0.857857SQL Server 2000 SP3+Q828017/827714/828308
8.0.856856SQL Server 2000 SP3+Q828096
8.0.854854SQL Server 2000 SP3+Q828699
8.0.852852SQL Server 2000 SP3+Q830466/827954
8.0.851851SQL Server 2000 SP3+Q826754
8.0.850850SQL Server 2000 SP3+Q826860/826815/826906
8.0.848848SQL Server 2000 SP3+Q826822
8.0.847847SQL Server 2000 SP3+Q826433
8.0.845845SQL Server 2000 SP3+Q826364/825854
8.0.844844SQL Server 2000 SP3+Q826080
8.0.842842SQL Server 2000 SP3+Q825043
8.0.841841SQL Server 2000 SP3+Q825225
8.0.840840SQL Server 2000 SP3+Q319477/319477
8.0.839839SQL Server 2000 SP3+Q823877/824027/820788
8.0.837837SQL Server 2000 SP3+Q821741/548/740/823514
8.0.819819SQL Server 2000 SP3+Q826161
8.0.818818SQL Server 2000 SP3+Q821277/337/818388/826161/821280
8.0.816816SQL Server 2000 SP3+Q818766
8.0.814814SQL Server 2000 SP3+Q819662
8.0.811811SQL Server 2000 SP3+Q819248/819662/818897
8.0.807807SQL Server 2000 SP3+Q818899
8.0.804804SQL Server 2000 SP3+Q818729
8.0.801801SQL Server 2000 SP3+Q818540
8.0.800800SQL Server 2000 SP3+Q818414/097/188
8.0.798798SQL Server 2000 SP3+Q817464
8.0.794794SQL Server 2000 SP3+Q817464/813524/816440/817709
8.0.791791SQL Server 2000 SP3+Q815249
8.0.790790SQL Server 2000 SP3+Q817081
8.0.789789SQL Server 2000 SP3+Q816840
8.0.788788SQL Server 2000 SP3+Q816985
8.0.781781SQL Server 2000 SP3+Q815057
8.0.780780SQL Server 2000 SP3+Q816084/810185
8.0.779779SQL Server 2000 SP3+Q814035
8.0.776776SQL Server 2000 SP3+Unidentified
8.0.775775SQL Server 2000 SP3+Q815115
8.0.769769SQL Server 2000 SP3+Q814889/93
8.0.765765SQL Server 2000 SP3+Q810163/688/811611/813769/813759/812995/814665/460/813494"
8.0.763763SQL Server 2000 SP3+Q814113
8.0.762762SQL Server 2000 SP3+Q814032
8.0.760760SQL Server 2000 SP3/SP3a
8.0.743743SQL Server 2000 SP2+Q818406/763
8.0.741741SQL Server 2000 SP2+Q818096
8.0.736736SQL Server 2000 SP2+Q816937
8.0.735735SQL Server 2000 SP2+Q814889
8.0.733733SQL Server 2000 SP2+Q813759
8.0.730730SQL Server 2000 SP2+Q813769
8.0.728728SQL Server 2000 SP2+Q814460
8.0.725725SQL Server 2000 SP2+Q812995/813494
8.0.723723SQL Server 2000 SP2+Q812798
8.0.721721SQL Server 2000 SP2+Q812250/812393
8.0.718718SQL Server 2000 SP2+Q811703
8.0.715715SQL Server 2000 SP2+Q810688/811611
8.0.714714SQL Server 2000 SP2+Q811478
8.0.713713SQL Server 2000 SP2/3+Q811205
8.0.710710SQL Server 2000 SP2/3+Q811052
8.0.705705SQL Server 2000 SP2+Q810920
8.0.703703SQL Server 2000 SP2+Q810526
8.0.702702SQL Server 2000 SP2+Q328551
8.0.701701SQL Server 2000 SP2+Q810026/810163
8.0.700700SQL Server 2000 SP2+Q810072
8.0.696696SQL Server 2000 SP2+Q810052/10
8.0.695695SQL Server 2000 SP2+Q331885/965/968
8.0.693693SQL Server 2000 SP2+Q330212
8.0.690690SQL Server 2000 SP2+Q311104
8.0.689689SQL Server 2000 SP2+Q329499
8.0.688688SQL Server 2000 SP2+Q329487
8.0.686686SQL Server 2000 SP2+Q316333
8.0.682682SQL Server 2000 SP3+Q319851
8.0.679679SQL Server 2000 SP2+Q316333
8.0.678678SQL Server 2000 SP2+Q328354
8.0.667667SQL Server 2000 SP2+8/14 fix
8.0.665665SQL Server 2000 SP2+8/8 fix
8.0.661661SQL Server 2000 SP2+Q326999
8.0.655655SQL Server 2000 SP2+7/24 fix
8.0.652652SQL Server 2000 SP2+Q810010?
8.0.650650SQL Server 2000 SP2+Q322853
8.0.644644SQL Server 2000 SP2+Q324186
8.0.608608SQL Server 2000 SP2+Q319507
8.0.604604SQL Server 2000 SP2+3/29 fix
8.0.599599SQL Server 2000 SP2+Q319869
8.0.594594SQL Server 2000 SP2+Q319477/319477
8.0.578578SQL Server 2000 SP2+Q317979/318045
8.0.561561SQL Server 2000 SP2+1/29 fix
8.0.558558SQL Server 2000 SP2+Q314003/315395
8.0.552552SQL Server 2000 SP2+Q313002/5
8.0.534534SQL Server 2000 SP2.01
8.0.532532SQL Server 2000 SP2
8.0.475475SQL Server 2000 SP1+1/29 fix
8.0.474474SQL Server 2000 SP1+Q315395
8.0.473473SQL Server 2000 SP1+Q314003
8.0.471471SQL Server 2000 SP1+Q313302
8.0.469469SQL Server 2000 SP1+Q313005
8.0.452452SQL Server 2000 SP1+Q308547
8.0.444444SQL Server 2000 SP1+Q307540/307655
8.0.443443SQL Server 2000 SP1+Q307538
8.0.428428SQL Server 2000 SP1+Q304850
8.0.384384SQL Server 2000 SP1
8.0.296296SQL Server 2000 No SP+Q299717
8.0.287287SQL Server 2000 No SP+Q297209
8.0.251251SQL Server 2000 No SP+Q300194
8.0.250250SQL Server 2000 No SP+Q291683
8.0.249249SQL Server 2000 No SP+Q288122
8.0.239239SQL Server 2000 No SP+Q285290
8.0.233233SQL Server 2000 No SP+Q282416
8.0.231231SQL Server 2000 No SP+Q282279
8.0.226226SQL Server 2000 No SP+Q278239
8.0.225225SQL Server 2000 No SP+Q281663
8.0.223223SQL Server 2000 No SP+Q280380
8.0.222222SQL Server 2000 No SP+Q281769
8.0.218218SQL Server 2000 No SP+Q279183
8.0.217217SQL Server 2000 No SP+Q279293/279296
8.0.211211SQL Server 2000 No SP+Q276329
8.0.210210SQL Server 2000 No SP+Q275900
8.0.205205SQL Server 2000 No SP+Q274330
8.0.204204SQL Server 2000 No SP+Q274329
8.0.194194SQL Server 2000 RTM/No SP
8.0.190190SQL Server 2000 Gold, no SP
8.0.100100SQL Server 2000 Beta 2
8.0.07878SQL Server 2000 EAP5
8.0.04747SQL Server 2000 EAP4
7.0.11521152SQL Server 7 SP4+Q941203 / 948113
7.0.11501150SQL Server 7.0 SP4+Q891116
7.0.11491149SQL Server 7.0 SP4+Q867763
7.0.11441144SQL Server 7.0 SP4+Q830233
7.0.11431143SQL Server 7.0 SP4+Q829015
7.0.10971097SQL Server 7.0 SP4+Q822756
7.0.10941094SQL Server 7.0 SP4+Q815495
7.0.10941094SQL Server 7.0 SP4+Q821279
7.0.10931093SQL Server 7.0 SP4+Q820788
7.0.10871087SQL Server 7.0 SP4+Q814693
7.0.10791079SQL Server 329499
7.0.10781078SQL Server 7.0 SP4+Q327068
7.0.10771077SQL Server 7.0 SP4+Q316333
7.0.10631063SQL Server 7.0 SP4 - All languages
7.0.10331033SQL Server 7.0 SP3+Q324469
7.0.10261026SQL Server 7.0 SP3+Q319851
7.0.10041004SQL Server 7.0 SP3+Q304851
7.0.996996SQL Server 7.0 SP3+Q299717
7.0.978978SQL Server 7.0 SP3+Q285870
7.0.977977SQL Server 7.0 SP3+Q284351
7.0.970970SQL Server 7.0 SP3+Q283837/282243
7.0.961961SQL Server 7.0 SP3 - All languages
7.0.921921SQL Server 7.0 SP2+Q283837
7.0.919919SQL Server 7.0 SP2+Q282243
7.0.918918SQL Server 7.0 SP2+Q280380
7.0.917917SQL Server 7.0 SP2+Q279180
7.0.910910SQL Server 7.0 SP2+Q275901
7.0.905905SQL Server 7.0 SP2+Q274266
7.0.889889SQL Server 7.0 SP2+Q243741
7.0.879879SQL Server 7.0 SP2+Q281185
7.0.857857SQL Server 7.0 SP2+Q260346
7.0.842842SQL Server 7.0 SP2
7.0.839839SQL Server 7.0 SP2 Unidentified
7.0.835835SQL Server 7.0 SP2 Beta
7.0.776776SQL Server 7.0 SP1+Q258087
7.0.770770SQL Server 7.0 SP1+Q252905
7.0.745745SQL Server 7.0 SP1+Q253738
7.0.722722SQL Server 7.0 SP1+Q239458
7.0.699699SQL Server 7.0 SP1
7.0.689689SQL Server 7.0 SP1 Beta
7.0.677677SQL Server 7.0 MSDE O2K Dev
7.0.662662SQL Server 7.0 Gold+Q232707
7.0.658658SQL Server 7.0 Gold+Q244763
7.0.657657SQL Server 7.0 Gold+Q229875
7.0.643643SQL Server 7.0 Gold+Q220156
7.0.623623SQL Server 7.0 Gold (RTM), no SP
583 SQL Server 7.0 RC1
517 SQL Server 7.0 Beta 3
6.50.480SQL Server 6.5 Post SP5a+Q238621
6.50.479SQL Server 6.5 Post SP5a
6.50.464SQL Server 6.5 SP5a+Q275483
6.50.416SQL Server 6.5 Bad SP5a
6.50.415SQL Server 6.5 Bad SP5
6.50.339SQL Server 6.5 Y2K Hotfix
6.50.297SQL Server 6.5 Site Server 3
6.50.281SQL Server 6.5 SP4
6.50.259SQL Server 6.5 SP3 SBS Only
6.50.258SQL Server 6.5 SP3
6.50.252SQL Server 6.5 Bad SP3
6.50.240SQL Server 6.5 SP2
6.50.213SQL Server 6.5 SP1
6.50.201SQL Server 6.5 Gold
6.0.151SQL Server 6.0 SP3
6.0.139SQL Server 6.0 SP2
6.0.124SQL Server 6.0 SP1
6.0.121SQL Server 6.0 No SP






Posted by at No comments:
Labels:

Thursday, December 24, 2009

Dashboard Creation

Dashboard Creation

Below notes is my quick overview helps in creating the dashboard (reports) (mostly for SQL 2005, SSRS 2005) and in particular to decision making.

Dashboards
  • To deliver information for (day-to-day) decision making
  • Real time business intelligence. Snapshots of KPIs, Trend Graphs, Ad-hoc Reports and more ...
  • With drill down capability, summary levels to detail levels for better results.
Below Steps can be used for quickly building the dashboard

Step 1: Identify and choose the data to be displayed.
  • Data sources, connection strings
  • Source Tables, Columns, its data types
  • Prepare the list of calculations, grouping, where conditions or other statements like case
  • Any other important SQL information
Step 2: Choose Layout
  • Design on paper first or atleast the rough sketch
  • For charts, consider titles, legends, colors, heading, details, type - atleast select bar or pie to start with, later we can change
  • Grids - headings, rows, column groupings, aggregations - totals / sums, % variances, % calculations, Period / dates and more ... purely derive from BA and Data. Create a mockup in Excel, easy and then we can go get the same from SQL.
Step 3: Data Conversion
  • Pick the data sources. If only one, it is simple and no need to worry about linking.
  • Prepare the data for report so that it can be used. For ex: which goes to x-axis, y-axis, series ...
  • Configuration / parameter details
  • Integration w/ other data sets
Step 4: Paper design of layout

Paper design of layout - Grid / Chart / both

Step 5: Getting together

Put data & layout together --> w/ report data, datasets & parameters. Resources --> embedded images. Write Unit test.
"Intermediate result and presentation is ready"

Step 6: Conceptualize plan of interactivity

For better readability, usability with different modules.

Step 7: Data for Interactive Dashboard

Test with integration by developer.

Step 8: Interactive Dashboard

with Business Users. Run through the requirements, colors, look & feel, interactivity.

Enjoy the dashboard!!!

Dashboard
  • Performance
  • Executive
  • Metrics
  • Analytics (BI)
Design considerations
  • Zoomable or go to details of data
  • #1. Put the user first
  • #2. Right medium: Graph / Chart ... for better communication & to what level
  • #3. Color selection
  • #4. Layout optimization
  • #5. Keep dashboards to one page (for executives)

Posted by at No comments:
Labels: , , ,

Friday, November 6, 2009

SQL Useful Links


Video Tutorials - to learn sql:

you can browse these sites for basic learning of SQL (for newbies only) and once you are familiar with concepts and way to do, then read a book or in parallel with videos. Together, you can learn SQL very nice. Enjoy!






Useful Links (Extract from http://www.sqlskills.com/links.asp)
Microsoft Related Resource Links
www.microsoft.com/sql - SQL Server Home Page
www.microsoft.com/sql/community - SQL Server Community Page
www.microsoft.com/sql/community/newsgroups - SQL Server Newsgroups Page
www.microsoft.com/sql/partners - Partner Products

Industry Experts Sites
www.sqldev.net - Gert Draper's site
www.betav.com - William R. Vaughn's site
www.sqldts.com - Darren Green's DTS Site
www.sql.co.il - Itzik Ben-Gan's Site
www.InsideSQLServer.com - Kalen Delaney's Site
www.callsql.com/en - Fernando Guerrero's Site
www.mssqlserver.com - Mike Hotek's Site
www.prospice.com - Ron Talmage's Site

Excellent Sites with Useful Information
www.sswug.org - SQL Server Worldwide User's Group
www.databasejournal.com/features/mssql - Database Journal
www.sql-server-performance.com - SQL Server Performance
www.sqlservercentral.com - SQL Server Central Web Community
www.solidqualitylearning.com - Solid Quality Learning
www.sqljunkies.com - SQL Junkies

Usergroups
www.sqlpass.org - Professional Association of SQL Server
www.pnwsql.org - Pacific Northwest SQL Server User's Group

Magazine and Technical Journal Sites
www.sqlmag.com - SQL Server Magazine
www.tsqlsolutions.com - TSQLSolutions Journal

Conference Sites
www.sqlmaglive.com - Featuring SQL Server Magazine Authors at two conferences in the US each year!
www.sqlpass.org - Featuring Industry Experts at their annual summit.
www.microsoft.com/teched - Microsoft Tech·Ed.
Posted by at No comments:
Labels: , ,
Subscribe to: Posts (Atom)