| mssqlserver.com: SQL Server FAQ |
| mssqlserver.com: SQL Server FAQ |
| http://www.mssqlserver.com/faq/ |
| By Neil Pike and Michael Hotek. |
| |
| SQL Server, SQL Server 2005, SQL Server 7, SQL 7, BackOffice, Hotek, databases, Mike Hotek, tutorial s, SQL, MSSQL, TSQL, replication, backup, SMS, Site Server, certification, scripts, stored procedure s, FAQ, SQL Server FAQ, SQL Server 2000, SQL 2000, SQL Server 6.5, SQL 6.5, Embarcadero, Lumigent, D BArtisan, disaster recovery, product reviews, reviews, database, DBA, database mirroring, partitioni ng, failover clustering, performance tuning high availability, SQL Server training, Reporting Servic es, Integration Services, Analysis Services, SSRS, SSIS, SSAS, Data Mining, OLAP, MDX, DMX, XMLA, Bl owFrog Software, SQL Server 2008, Reporting Services training, Integration Services training, Analys is Services training, SQL Server certification |
| search, mssqlserver, server |
| (SLD : mssqlserver.com) |
|
| zum Seitenanfang ↑ |
| SQL Server Replication FAQ |
| SQL Server 7.0 Replication FAQ and common problems: Narayana Vyas Kondreddi's home page |
| http://vyaskn.tripod.com/repl_ques.htm |
| FAQs on SQL Server replication and solutions to common problems. By Narayana Vyas Kondreddi. |
| Welcome to the website of Narayana Vyas Kondreddi. This is a personal website, with some technical s tuff which you will find useful. This site features some great SQL Server, Visual Basic, ASP resourc es. You will also find an FAQ section on SQL Server replication. You will also find a list of handy shortcut keys of some Microsoft products. Additional sections include: A code library which features VB programs, stored procedures; A page dedicated to SQL Server related books; |
| Narayana Vyas Kondreddi, Narayana Kondreddi, Vyas Kondreddi, Vyas, Vyaskn, Kondreddi, Veeravasaram, Narsapur, Narasapuram, Bhimavaram, Rajahmundry, Eluru, Bangalore, Andhra Pradesh, Brazil, Sao Paulo, Rio, Dallas, TX, Texas, Irving, Bellevue, Seattle, Washington, Gopala Krishna, Nagaja Devi, Subhadr a Jyothsna, Geetha Madhuri, Madhuri, Vijaya Madhuri, Govindaraju, tips, tricks, code, code samples, snippets, code snippets, FAQ, FAQs, Aditi, Talsima, links, resources, SQL Server, Microsoft, support , databases, design, replication, T-SQL, scripts, sql, Visual Basic, VB, VBScript, ASP, code library , performance, active server pages |
| background, height, social, position, images, important, repeat, window, search, replication, margin , document, container, button, server, display, padding, jquery, replication, tripod, agents, catego ry, failing, decoration, errors, function, following, section, onbutton, relative, adbanner, sprite, documentelement, onshare, onsearch, resources, return, clientheight, clientwidth, subscriber, setfo rcedparam, hidden, center, replicated, animate, normal, family, common, running, publisher, update |
tripod.com - rank der domain 857 (45 in JP)
|
|
| zum Seitenanfang ↑ |
| Troubleshooting Microsoft SQL Server FAQ |
| Shakhov's MSSQL page |
| http://www15.brinkster.com/shakhov/ |
| Various troubleshooting Microsoft SQL Server FAQ artricles in both English and Russian. |
| |
| |
| shakhov, language, choose |
brinkster.com - rank der domain 24761 (9216 in US)
|
|
| zum Seitenanfang ↑ |
| Computers/Software/Databases/Microsoft_SQL_Server/FAQs,_Help,_and_Tutorials |
|
|
| Computers/Software/Databases/Microsoft_SQL_Server/FAQs,_Help,_and_Tutorials |
| zum Seitenanfang ↑ |
| SQLXML FAQ Site |
| sqlxml.org home |
| http://sqlxml.org/ |
| SQLXML.org is a developer resource that provides answers to frequently asked questions about SQL Ser ver XML. |
| SQLXML.org provides developers with answers to frequently asked questions about SQLXML technologies. |
| sqlxml; openxml; xml for sql; xml templates; for xml explicit; microsoft sql server 2000; sql; xml; updategrams; faqs; examples; tutorials |
| server, results, openxml, sqlxml, retrieve, document, performance, sqlxml, format, update, request, extract, number, columns, commands, install, unable, different, insert, allowed, element, specify, i nsert, statement, openxml, clause, saying, metaproperties, andrew, conrad, joshua, survey, perfect, magazine, article, obasanjo, information, bryant, optimizing, experts, retrieving, writing, wednesda y, general, contact, extreme, within, latest, default, namespace, practices |
sqlxml.org - rank der domain 951518 (389488 in US)
|
|
| zum Seitenanfang ↑ |
| SQL Server Database Recovery |
| SQL Recovery and SQL Server Database Recovery |
| http://www.sql-recovery.com/ |
| SQL Server database recovery information. |
| Discusses SQL server database recovery, related problems and backup tips. |
| sql server database recovery, access database recovery, data recovery, data loss, file recovery, har d drive, hard disk, improving sql performance |
| database, recovery, recovery, server, database, server, problems, system, failure, unable, partition s, physical, business, problems, drives, breakdowns, successfully, failures, access, professional, b ackup, models, disaster, emergencies, physical, access, software, articles, logical, percent, damage , system, accidental, systems, servers, efficient, maintenance, programs, backing, process, crucial, prevent, backups, frequent, configured, therefore, backup, restored, different, models, program |
| (SLD : sql-recovery.com) |
|
| zum Seitenanfang ↑ |
| SQLDTS.com - Data Transformation Services |
| |
| http://www.sqldts.com |
| Articles, code samples, and tools help with development of robust and flexible Data Transformation S ervices (DTS) packages. |
| |
| |
| |
sqldts.com - rank der domain 955097 (16496 in NL)
|
|
| zum Seitenanfang ↑ |
| Weblogs @ SQL Advice |
| SqlAdvice - Blogs |
| http://sqladvice.com/blogs/ |
| A collection of weblogs focusing on all aspects SQL Server. |
| |
| |
| server, ratings, aggposts, comments, gstark, default, ratecontrol, images, database, themes, excelle nt, common, terrible, average, commonratecontrolreadonly, commonratecontrolactive, commonratecontrol , management, studio, recently, hosting, queries, started, microsoft, running, reddit, needed, datab ase, configure, bookmark, window, enable, annoying, instances, posted, procedure, stored, animation, easily, following, retrieve, archive, really, convert, through, longer, enable, serverproperty, var char, because, stephen |
sqladvice.com - rank der domain 989186 (422396 in US)
|
|
| zum Seitenanfang ↑ |
| 2000 Trainers: SQL Server Tutorials |
| SQL Server Tutorials · 2000Trainers.com |
| http://www.2000trainers.com/tutorials/sql-server/ |
| Collection of tutorials covering a range of topics. |
| |
| |
| server, chapter, database, tables, tutorials, database, design, backup, windows, design, constraint, transaction, logical, logical, alinks, remote, column, backups, services, simple, creating, recover y, enterprise, manager, submit, search, another, restoring, stored, things, physical, restoring, acc ess, creating, disaster, modification, decide, example, recovery, control, search, referential, cons traints, gettime, exittime, modifications, numbermillis, keyphrase, function, 2000trainers, trackima ge |
2000trainers.com - rank der domain 742476 (303036 in US)
|
|
| zum Seitenanfang ↑ |
| Computers/Software/Databases/Microsoft_SQL_Server/FAQs,_Help,_and_Tutorials |
|
|
| Computers/Software/Databases/Microsoft_SQL_Server/FAQs,_Help,_and_Tutorials |
| zum Seitenanfang ↑ |
| Unstructured Data SQL 2008 |
| SQL Server 2008 Overview, data platform, store data | Microsoft |
| http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_unstructured.mspx |
| Tutorial on Managing Unstructured Data with SQL Server 2008 by Graeme Malcolm. |
| |
| |
| subhero, special, border, d1d9ec, padding, height, document, server, margin, getelementbyid, charcod e, return, microsoft, function, position, searchcontrol, getelementsbytagname, navigator, intelligen ce, doimage, business, vendor, indexof, osearchbox, msvilsbtbox, bottom, absolute, sqlherocontainer, download, service, overview, dcsext, secure, critical, mission, access, editions, resourcestrusted, scalable, platform, healthcare, credit, cookie, powerful, systems, enhance, information, company, r esources, trademarks, contact |
microsoft.com - rank der domain 31 (17 in US)
|
|
| zum Seitenanfang ↑ |
| FileStream SQL 2008 |
| Getting Traction with SQL Server 2008 Filestream - rdoherty's WebLog - Site Home - MSDN Blogs |
| http://blogs.msdn.com/rdoherty/archive/2007/10/12/getting-traction-with-sql-server-2008-filestream.aspx |
| Tutorail on using the FileStream in SQL 2008 by R Doherty. |
| SQL Server |
| SQL Server |
| weblog, rdoherty, server, roleiconareahtml, roleicons, userrankareahtml, userrank, points, pointcoun tareahtml, pointcountarea, postcountareahtml, roleiconarea, userrankarea, postcount, pointcount, 403 d011d5de4, breadcrumb, addclass, postcountarea, function, userinfopopup, attachtouserelements, bb4b4 c05, fragment, document, message, doherty, traction, getting, filestream, technical, evangelist, fri end, postsatom, userinfohtml, postrank, displayname, author, devleoper, microsoft, platform, evangel ism, homeemail, options |
| (SLD : msdn.com) |
|
| zum Seitenanfang ↑ |
| SQL Server From Squirrel's View |
| Squirrel’s SQL Server Blog |
| http://www.lockergnome.com/sqlsquirrel/ |
| Providing solutions and tips to everyday SQL Server problems. |
| |
| msrepl_commands,msrepl_transactions,replication,sp_browsereplcmds,initialize variables,sql server 20 08,tsql,dm_tran_locks,mode,request_mode,sch-m,sch-s,sp_lock,sql server 2000,sql server 2005,import,i mport servers,sql server list,ssms,kill,kill remote desktop sessions,rdp,remote desktop session,sql server,sqlskills,transaction log,vlf,vlfs,microsoft,programming,sid,sids,sp_change_users_login,sql,s ync logins,syslogins,dts,dts packages,jobs,lineage,log,logging,baseline,hardware bottlenecks,load,pe rf mon,performance counters,performance monitor,black box trace,perf counters,performance issues,sql profiler,sql trace |
| server, content, sidebar, comments, active, visited, distribution, database, family, comment, wednes day, squirrel, replication, function, january, comment, saturday, posted, expires, servers, informat ion, tricks, replication, tuesday, commands, msrepl, transactions, fixing, transaction, optimizing, desktop, connections, orphaned, document, subscribe, animate, height, duration, remote, importing, d ifferent, counters, performance, return, easing, querying, tables, collecting, baseline, lockergnome , 8e2800 |
lockergnome.com - rank der domain 11990 (4519 in US)
|
|
| zum Seitenanfang ↑ |
| PIVOT in SQL Server 2005 |
| Give the New PIVOT and UNPIVOT Commands in SQL Server 2005 a Whirl |
| http://www.devx.com/dbzone/Article/28165 |
| Learn to combine SQL Server's PIVOT and UNPIVOT commands with Common Table Expressions by Michael Jo nes. |
| Sometimes it's the little things that can simplify your life the most. Learn to combine SQL Server's PIVOT and UNPIVOT commands with Common Table Expressions to make your T-SQL code easier to read and produce more useful crosstabbed results. |
| java, hibernate, programming |
| theform, document, jomfooter, required, islands, validate, element, solutions, republic, function, c fform, frmphone, height, minlength, characters, discussion, server, frmemail, articlespptitems, minu te, solsect, itemname, development, padding, management, return, margin, frmpassword1, island, passw ord, theurl, database, frmcompany, center, tutorials, articles, frmzipcode, downloads, frmlastname, frmcity, frmaddress, decoration, frmfirstname, special, please, address, number, visual, company, un ited, report |
devx.com - rank der domain 11031 (4067 in US)
|
|
| zum Seitenanfang ↑ |
| MS SQL Guide |
| MS SQL Server Administration |
| http://www.mssqlguide.com/ |
| Series of articles on Microsoft SQL Server tasks. |
| |
| |
| server, server, administration, members, database, database, integration, services, installation, ad ministrator, packages, functions, creation, management, software, situation, sysadmin, dbcreator, di skadmin, processadmin, securityadmin, serveradmin, stored, procedures, servers, defined, protection, cannot, introduction, backups, replication, configuration, performed, parameters, shutting, activit ies, controlled, completely, overall, change, function, databases, deleted, outside, policy, applica tion, modified, setupadmin, internet, member, privacy |
| (SLD : mssqlguide.com) |
|
| zum Seitenanfang ↑ |
| Creating a Simple ETL Package for SQL Server |
| Tutorial: Creating a Simple ETL Package |
| http://msdn.microsoft.com/en-us/library/ms169917.aspx |
| This tutorial walks you through SSIS Designer to create a simple ETL package that includes looping, configurations, error flow logic and logging. |
| |
| |
| package, tutorial, adding, lesson, integration, features, services, lesson, server, sample, create, designer, creating, packages, advantage, connect, created, expand, default, available, simple, confi gurations, logging, installed, looping, microsoft, simple, install, following, options, single, impl ementing, programming, database, between, control, elements, databases, previous, design, configurat ion, completed, success, tutorial, constraint, samples, enhance, building, packagelesson, includes, project |
microsoft.com - rank der domain 31 (17 in US)
|
|
| zum Seitenanfang ↑ |
| Replication with SQL Server 2000 |
| Replication: SQL Server 2000 - Part 1 |
| http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000--Part-1/ |
| Explanation of Replication with SQL Server 2000 by Mahesh Kodli. |
| Replication: SQL Server 2000 - Part 1 |
| Replication:, SQL, Server, 2000, -, Part, 1 |
| server, design, 290307, replication, sheets, reviews, photoshop, oracle, services, generation, mobil e, authoring, standards, visual, forums, articles, apache, coldfusion, urchintracker, window, google , analytics, delphi, graphic, interviews, usability, development, cycles, embedded, javascript |
devarticles.com - rank der domain 14877 (5546 in US)
|
|
| zum Seitenanfang ↑ |
| SQL Server Service Broker Introduction |
| An Introduction to SQL Server Service Broker |
| http://msdn.microsoft.com/en-us/library/ms345108.aspx |
| Introduction and definition of SQL Server Service Broker by Roger Wolter. |
| |
| |
| messages, broker, service, application, message, database, messaging, conversation, server, received , transaction, example, dialogs, stored, processed, process, system, processing, associated, instanc e, running, sender, multiple, inventory, messaging, shipping, applications, procedure, receive, acro ss, systems, external, threads, readers, thread, server, single, dialog, difficult, issues, particul ar, because, transactional, incoming, microsoft, receives, service, processes, before, receivers, tr ansactional |
microsoft.com - rank der domain 31 (17 in US)
|
|
| zum Seitenanfang ↑ |
| Spatial Data with SQL Server 2008 |
| SQL Server 2008: Spatial Data, Part 1 |
| http://jasonfollas.com/blog/archive/2008/03/14/sql-server-2008-spatial-data-part-1.aspx |
| Introduction to Spatial Data concepts as well as detailed SQL Server instructions on use by Jason Fo llas. |
| |
| |
| spatial, server, points, geometry, represent, system, actually, projection, uniform, distance, coord inate, between, single, meridian, reference, information, longitude, syntaxhighlighter, spatial, geo graphy, instance, february, polygons, system, november, database, create, different, latitude, locat ion, accurate, school, define, projections, closed, perfect, coordinate, impressed, thanks, mathemat ical, geospatial, connected, calculate, another, particular, because, radius, measure, starting, com monly, through |
| (SLD : jasonfollas.com) |
|
| zum Seitenanfang ↑ |
| SQL Server 2005 Paging |
| SQL Server 2005 Paging – The Holy Grail - SQLServerCentral |
| http://www.sqlservercentral.com/articles/T-SQL/66030/ |
| Article explores four approaches for coding SQL when results will be returned to an application that supports paging by Robert Cary. |
| Free Microsoft SQL Server articles, news, forums, scripts and FAQs. |
| Microsoft SQL Server, SQL Server, SQL Server 2000, Yukon, SQL Server 7.0, SQL Server DBA |
| physical, logical, column, startrow, select, approach, columns, number, overhead, solution, sysschob js, information, worktable, schema, logical, pgeresults, number, startrow, syscolpars, paging, affec ted, return, declare, result, tables, between, records, problem, article, document, physical, server , totrows, sequential, screen, results, because, underlying, register, height, searchbar, subset, lo cation, querying, totrows, database, represent, protocolandserver, example, record, articles |
sqlservercentral.com - rank der domain 12726 (4703 in US)
|
|
| zum Seitenanfang ↑ |
| How to Transfer SQL Logins between SQL Server 2005 Instances |
| How to transfer SQL logins between SQL Server 2005 instances |
| http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx |
| Articles presents a custom script as well as standard options for moving SQL logins between servers by Tara Kizer. |
| |
| |
| server, between, logins, transfer, server, loginname, instances, password, loginid, varbinary, login s, statement, script, create, master, select, december, september, nvarchar, november, syntax, janua ry, 1incorrect, convert, policy, hashed, passwordhashold, october, jeroen, august, passwordhashnew, account, create, hexadecimal, coalesce, passwordhash, mirroring, solution, function, output, submits earch, password, sqlteam, principals, return, synchronize, february, openquery, method, passwordhash , linkedservername |
sqlteam.com - rank der domain 15939 (5863 in US)
|
|
| zum Seitenanfang ↑ |
| The Future of SQL Data Services with Nigel Ellis |
| The Future of SQL Data Services with Nigel Ellis | ZachSkylesOwens | Channel 9 |
| http://channel9.msdn.com/posts/ZachSkylesOwens/The-Future-of-SQL-Data-Services-with-Nigel-Ellis/ |
| Interview discussing the future direction of SQL Data Services. |
| I had the pleasure of sitting down with one of SQL Server’s brightest, Nigel Ellis, to discuss the future direction of SQL Data Services. Nigel goes deep on the changes of SDS. If yo u want to learn… |
| Azure,SQL Data Services,SQL Server,TechEd |
| delete, pending, download, server, services, storage, channel, zachskylesowens, nigele, tweetmeme, f uture, really, database, france, databases, windows, planning, studio, silverlight, tenant, visual, twitter, coming, microsoft, cdwatkins, theframes, backup, should, queries, support, indexes, pivotvi ewer, control, exchange, something, access, people, stored, developing, hybrid, consumed, varbinary, chance, compression, charge, concurrency, related, sokhaty, templates, available, optimistic |
| (SLD : msdn.com) |
|
| zum Seitenanfang ↑ |
| Distributed Partitioned Views - Federated Databases: Lessons Learned |
| Distributed Partitioned Views / Federated Databases: Lessons Learned - Microsoft SQL Server Development Customer Advisory Team - Site Home - MSDN Blogs |
| http://blogs.msdn.com/sqlcat/archive/2007/06/20/distributed-partitioned-views-federated-databases-lessons-learned.aspx |
| This article contains information about the things we have learned while working with Federated Data bases by Kevin Cox. |
| |
| |
| captcha, subtext, fragment, bpcommentform, invisiblecaptcha, invisible, content, server, microsoft, development, customer, advisory, function, userinfopopup, attachtouserelements, document, roleiconar eahtml, roleicons, addclass, 403d011d5de4, hidefromjavascriptenabledbrowsers, userrank, answer, bb4b 4c05, setanswer, breadcrumb, postcountareahtml, options, author, homeaboutemail, partitioned, distri buted, federated, databases, learned, lessons, friend, roleiconarea, userrankarea, pointcountarea, p ostcount, points, pointcount, pointcountareahtml, postcountarea, postsatom, message, userinfohtml, p ostrank, displayname, userrankareahtml |
| (SLD : msdn.com) |
|
| zum Seitenanfang ↑ |
| How to Transfer the Logins and the Passwords between Instances of SQL Server 2005 |
| How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008 |
| http://support.microsoft.com/kb/918992/ |
| Microsoft knowledge-base article containing instructions and a script to run. |
| Describes how to transfer the logins and the passwords between&# 32;instances of SQL Server 2005 and SQL Server 2008. |
| kbexpertiseadvanced kbhowto kbinfo KB918992 |
| server, server, statsdotnet, declare, tmpstr, script, instance, logins, networklink, select, support , database, microsoft, microsoft, information, following, kbsurvey, output, passwords, varbinary, tr ansfer, checked, function, support, library, varchar, addsubmitfield, visits, article, disabled, cre ate, statement, default, return, 918992, networkfooter, window, hexadecimal, different, revlogin, lo adtocnode, domain, original, denylogin, string, policy, hasaccess, between, instances, length, defau ltdb |
microsoft.com - rank der domain 31 (17 in US)
|
|
| zum Seitenanfang ↑ |
| SQL 2008 Filestream Example |
| More on Filestream in SQL 2008 - Mike Taulty's Blog - Mike Taulty's Blog |
| http://mtaulty.com/CommunityServer/blogs/mike_taultys_blog/archive/2007/10/23/9886.aspx |
| Example of FILESTREAM in SQL 2008 by Mike Taulty. |
| I wrote a little demo around FILESTREAM in SQL 2008 so I thought I'd share - the code's a little sha bby but I got to the point where it did what I wanted and so I stopped. Some days I miss not writing production code because it's very different from demo code and the differences are where I used to enjoy spending my time. Anyway, regardless...you need this SQL script to set up the single table inv olved here (or at least something a bit like it); use master go -- Switching the thing on in the fir st place. EXEC sp_filestream_configure @enable_level = 3; -- Need a filegroup that supports it too. USE master; GO IF EXISTS ( SELECT * FROM sys.databases WHERE name = N 'PhotoDB' ) DROP DATABASE Phot oDB GO CREATE DATABASE PhotoDB ON PRIMARY ( NAME = PhotoDB_data, FILENAME = N 'D:\data\PhotoDb.mdf' , SIZE = 10MB, MAXSIZE = 50MB, FILEGROWTH = 15%), FILEGROUP PhotoDBFS CONTAINS FILESTREAM ( NAME = P hotoDB_FS, FILENAME = N 'D:\data\Photos' ) LOG ON ( NAME = 'PhotoDB_log' , FILENAME = N 'D:\data\Pho toDB_log.ldf' , SIZE = 5 |
| www.mtaulty.com |
| october, december, september, august, january, november, february, photodb, taulty, filestream, open sqlfilestream, access, syntaxhighlighter, filename, filestream, filestream, pagetracker, script, rep lace, another, implied, requests, master, little, document, gajshost, handle, filegrowth, maxsize, w eblog, provided, comments, photos, rights, import, mtaulty, database, changes, button, warranties, e ither, andrewbelon, merchantability, couple, limited, requeries, database, pulling, finally, varbina ry, selected |
mtaulty.com - rank der domain 545692 (206966 in US)
|
|
| zum Seitenanfang ↑ |
| SQL Server 2008 Resource Governor in action |
| SQL Server 2008 Resource Governor in action - Insufficent data from Andrew Fryer - Site Home - TechNet Blogs |
| http://blogs.technet.com/andrew/archive/2008/02/06/sql-server-2008-resource-governor-in-action.aspx |
| Short blogcast demo of the Resource Governor in action. |
| Notes and queiries from a Microsoft technical evangelist for the IT Professional working in the UK |
| SQL Server, Cloud, Infrastructure Optimisation, Consolidation, Virtualisation |
| subtext, fragment, captcha, document, invisible, andrew, pagetracker, gajshost, insufficent, content , invisiblecaptcha, bpcommentform, userrank, userrankareahtml, pointcount, pointcountareahtml, point s, postcountarea, postsatom, postrank, displayname, userinfohtml, message, postcountareahtml, roleic onarea, userrankarea, pointcountarea, postcount, userinfopopup, answer, setanswer, hidefromjavascrip tenabledbrowsers, breadcrumb, addclass, 2c571ef4fabf, function, roleicons, 6ae902e0, attachtouserele ments, roleiconareahtml, microsoft, gettracker, script, javascript, 6544227, server, trackpageview, location, protocol, unescape, 3cscript |
technet.com - rank der domain 4887 (1812 in US)
|
|
| zum Seitenanfang ↑ |
| Paging Records Using SQL Server ROW_NUMBER Function |
| Paging Records Using SQL Server 2005 Database - ROW_NUMBER Function |
| http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx |
| SQL Server has a ROW_NUMBER Function that can help with paging records for you database applications by David Hayden. |
| |
| |
| server, number, select, factory, description, software, records, design, library, service, enterpris e, client, development, function, database, patterns, logwithrownumbers, follows, sqltransaction, re cords, paging, concurrency, rollback, pageindex, management, pagesize, transaction, framework, pagin g, guidance, hayden, transactions, logentries, sarasota, system, databases, friday, idisposable, web sites, optimistic, december, posted, statement, updating, performance, pessimistic, applications, ex press, graphical, studio, microsoft |
davidhayden.com - rank der domain 586725 (239554 in US)
|
|
| zum Seitenanfang ↑ |
| SQL Server Toolkit |
| SQL Server Database | SQL Server Management | SQL Server Backup |
| http://www.sqlservertoolkit.com |
| SQL Server tips and tricks. |
| |
| |
| server, database, needing, database, double, problems, toolkit, content, sqlservertoolkit, plugins, banners, tables, methods, whether, columns, sitemap, solution, working, aggregate, pagetracker, guid ence, getdate, developer, contact, timestamp, getutcdate, datatype, reduce, management, corruption, timezones, update, records, mirroring, height, studio, managment, problems, document, savings, gajsh ost, daylight, mirroring, approach, looking, shipping, packages, availability, clustering, provided, inside |
| (SLD : sqlservertoolkit.com) |
|
| zum Seitenanfang ↑ |
| Pivoting, Un-pivoting and Aggregating |
| Pivoting, Un-pivoting and Aggregating: A Quick Spin Around the Block |
| http://www.simple-talk.com/sql/t-sql-programming/pivoting,-un-pivoting-and-aggregating-a-quick-spin-around-the-block/ |
| Techniques in pivoting and un-pivoting data, and showing how the use of the CUBE or ROLLUP operator can be a more efficient way of generating reports by Phil Factor. |
| |
| |
| production, pretty, padding, margin, border, country, family, bottom, continent, server, weight, alg eria, member, grouping, select, posted, column, silver, oilproducersaggregate, article, aggregation, background, courier, cacaca, reports, strtext, courier, coalesce, rollup, november, oilproduction, articles, pivoting, command, yeargrouping, operator, function, america, simple, subject, message, re sult, crudeoilproduction, factor, profile, gothic, monospaced, importantwords, screentext, countrygr ouping, string |
simple-talk.com - rank der domain 31398 (11417 in US)
|
|
| zum Seitenanfang ↑ |
| User Defined Functions |
| User Defined Functions - SQLTeam.com |
| http://www.sqlteam.com/article/user-defined-functions |
| This article covers all the basics of User Defined Functions. It discusses how (and why) to create t hem and when to use them by Doug Carpenter, |
| This article covers all the basics of User Defined Functions. It discusses how (and why) to create them and when to use them. It talks about scalar, inline table-valued and multi-statement table-val ued functions. (This article has been updated through SQL Server 2005.) |
| |
| function, defined, server, country, functions, nvarchar, select, return, functions, select, sqlteam, ability, varchar, statement, defined, create, parameters, whichcontinent, command, replies, functio n, america, procedure, database, stored, customers, customers, article, scalar, address, customersby country, continent, returns, different, scalar, inline, europe, document, articles, creating, refere nce, object, powerful, country, create, function, returns, postalcode, contacttitle, contactname, co mpanyname |
sqlteam.com - rank der domain 15939 (5863 in US)
|
|
| zum Seitenanfang ↑ |
| SQL-SYS Training & Consulting |
| Home - SQL-SYS Training and Consulting (MS SQL Server) |
| http://www.sql-sys.com |
| Aricles, tips and tricks on SQL Server commands. Articles range from Isolation Levels to using the M erge statement. |
| This page is dedicated to provide content related to SQL Server 2008. It contains aricles, tips and tricks and other training materials regarding this technology. Also you can request our services lik e training, consulting, administration as well as development. |
| sql-sys, sql server, mcdba, przemyslaw chruscicki, chruscicki przemyslaw, chruscicki, training, cons ulting, administration, learn, materials, certifications, MCDBA, MCTS, MCITP |
| server, training, consulting, transactions, delete, truncate, tooltip, articles, concurrency, issues , forgot, basics, transactions, plugins, window, jceutilities, system, training, insert, welcome, up date, grouping, selects, simple, password, username, remember, password, latest, isolation, output, levels, username, administration, development, consulting, request, services, template, vonfio, prze myslaw, chruscicki, related, content, provide, dedicated, contains, aricles, technology, regarding, materials |
| (SLD : sql-sys.com) |
|
| zum Seitenanfang ↑ |
| Using SQL Server 2008 Upgrade Advisor |
| Using SQL Server 2008 Upgrade Advisor |
| http://databases.about.com/od/sqlserver/ht/sqlupgrade.htm |
| Article provides a step by step listing of using the SQL Server 2008 Upgrade Advisor by Mike Chapple . |
| Microsoft provides the SQL Server 2008 Upgrade Advisor to help you detect upgrade issues before they occur. This tool examines your SQL Server 2000 and SQL Server 2005 databases and checks for any po tential conflicts. |
| sql server upgrade advisor 2008 2005 2000 microsoft upgrading sql server databases |
| margin, decoration, databases, server, widgets, padding, upgrade, test30, adunit, function, nofollow , sharew, computing, technology, search, chapple, advisorby, corporation, microsoft, databasesif, sq lusing, databasesdatabase, basicslearning, classname, updiscuss, newsletter, underline, bottom, arti clebody, rating, layout, weight, 9999999, border, normal, advisor |
about.com - rank der domain 82 (42 in US)
|
|
| zum Seitenanfang ↑ |
| Introduction to SQL 2008 Integration Services |
| |
| http://download.microsoft.com/download/3/5/8/35802290-a7f6-4976-8855-74c8b3b7f035/ssis2008Intro.doc |
| This white paper gives a high level overview of SQL Server Integration Services 2008. Topics include why and when to use Integration Services as well as a flow components introduction. By Kamal Hathi. |
| |
| |
| |
microsoft.com - rank der domain 31 (17 in US)
|
|
| zum Seitenanfang ↑ |
|
