EDITORIAL - UNSTRUCTURED DATA
ADVERTISEMENT
ADVERTISEMENT
FEATURED ARTICLES
REVERSE ENGINEERING ALIAS DATA TYPES IN SQL SERVER 2000 - PART IV In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s). http://www.sqlservercentral.com/links/354811/9086
THE SUBSYSTEMS OF ETL REVISITED
These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.
http://www.sqlservercentral.com/links/354811/9088
MIRRORED BACKUP AND RESTORE COMMANDS IN SQL SERVER 2005 Mirrored backup commands in SQL Server 2005 work with media sets to minimize data loss. They can also restore a mirrored backup from a different media family. http://www.sqlservercentral.com/links/354811/9090
QUESTION OF THE DAY - A SERVER-SIDE REPORT CAN BE ACCESSED AT CLIENT-SIDE?
Read more at http://www.sqlservercentral.com/links/354811/9098
Today's Question is sponsored by: Client Side Reporting with Visual Studio in C# </a> by Asif Sayed Answer the question for a chance to win a copy of this great new book. We'll be giving away two copies from names drawn randomly from those who answer. It doesn't matter if you answer correctly or incorrectly, but you must live in the US to be eligible.
YESTERDAY'S QUESTION OF THE DAY - WHEN YOU IMPLEMENT A GROUP OF FEDERATED DATABASE...
FEATURED SCRIPT
DATABASE PROS WHO NEED YOUR HELP!
ADMINISTERING (http://www.sqlservercentral.com/Forums/Forum146-1.aspx)
COPY DATA FROM ONE COLUMN TO ANOTHER WITHIN THE SAME TABLE. - i've got a table [MyTable] with 3 columns.
account, column2, column3 (column3 is empty)
i basically have different accounts in the account... (http://www.sqlservercentral.com/Forums/FindPost416834.aspx)
LOST CONNECTIONS - We have recently deployed our database application on a new client site.
The application runs on 20 PC's (Windows XP) connected... (http://www.sqlservercentral.com/Forums/FindPost416814.aspx)
CAN WE BLOCK ODBC CONNECTIONS? - Is it possible to prevent or block ODBC connections to a specific database? We have a .Net web application that... (http://www.sqlservercentral.com/Forums/FindPost416812.aspx)
LOGGING INTO AND QUERYING READ ONLY STANDBY DATABASE - We have a Java web application that needs to be able to login to and query a warm standby database.... (http://www.sqlservercentral.com/Forums/FindPost416793.aspx)
STORED PROCS TIMING OUT AFTER 2005 UPGRADE - We've experienced two applications timing out after running an "in-place" upgrade from 2000 to 2005.
Are there some post-upgrade steps I...
(http://www.sqlservercentral.com/Forums/FindPost416768.aspx)
OWNER NAME AS A DBO PROBLEM - Please help... or give me ref where i can find the information on it. I browsed all around but couldn't... (http://www.sqlservercentral.com/Forums/FindPost416322.aspx)
CAN SAN READ+WRITE CACHE CAUSE OUT OF SYNC DB CALLS? - I have a SQL Server database connected to a Dell/EMC CX300 SAN Drive array system, we bought a SAN package... (http://www.sqlservercentral.com/Forums/FindPost416183.aspx)
COST AND CAL QUESTION - I am very new to SQL Server 2005. I have bought two different CBTs and understand a small portion of... (http://www.sqlservercentral.com/Forums/FindPost415747.aspx)
REPORT SERVER WINDOWS SERVICE APP ERROR 107 - I have an occasional recurring report server error in the app log:
Event ID:107
Report Server Windows Serive [MSSQLSERVER] cannot connect to... (http://www.sqlservercentral.com/Forums/FindPost414422.aspx)
LOGIN AUTHENTICATION SCREEN - I was having problems with Sql 2005 Sp1,sp2 versions were conflecting.i got that figured out but now in reporting services... (http://www.sqlservercentral.com/Forums/FindPost414120.aspx)
IMPOSSIBLE TO ATTACH ADVENTUREWORKS - I just installed SQL 2005 and I tried (repeatedly) to attach Adventureworks; it fails displaying the Message Box below.
I run DBCC...
(http://www.sqlservercentral.com/Forums/FindPost266762.aspx)
BACKUPS (http://www.sqlservercentral.com/Forums/Forum357-1.aspx)
DATABASE DISAPPERED - This morning went to use db sql express on vista home pc. ms access front end can't find it. see... (http://www.sqlservercentral.com/Forums/FindPost416881.aspx)
LITESPEED AND XP_DELETE_FILE - I have the following statement:
EXECUTE master.dbo.xp_delete_file 0,N'M:\Backups\db_admin',N'bkp', N'2007-10-28 18:34:26'
For files created with native SQL backup this deletes the files... (http://www.sqlservercentral.com/Forums/FindPost416841.aspx)
HOW TO: DETACH AN MIRRORED SQL 2005 DATABASE FROM C: TO THE D: DRIVE - Gents can you tell me how to do this?
HOW TO: Detach an Mirrored SQL 2005 database from C: to the... (http://www.sqlservercentral.com/Forums/FindPost416496.aspx)
RESTORE DB WITH 1 .MDF FILE INSTEAD OF 2 FILES. - I have a db that has 2 data files. I'd like to restore as one data file.
What's the best way...
(http://www.sqlservercentral.com/Forums/FindPost416116.aspx)
BACKUP TIME INCREASING - Hi,
I've been noticing that while taking a snapshot backup in MSSQL 2000 the time taken to backup the database completes... (http://www.sqlservercentral.com/Forums/FindPost415854.aspx)
PROBLEM WHILE RESTORING MASTER DATABASE - I have to restore 'master' database in sql server 2005. The server has two instances. As part of restore strategy,... (http://www.sqlservercentral.com/Forums/FindPost414202.aspx)
ERROR IN RESTORING SQL SERVER 2000 DB TO SQL SERVER 2005 - Hi there,
I'm trying to migrate a SQL Server 2000 DB to SQL Server 2005.
Here's what I did:
BUSINESS INTELLIGENCE (http://www.sqlservercentral.com/Forums/Forum147-1.aspx)
SSRS: ADDING CUSTOM PAGE INSTEAD OF DEFAULT PAGE - Hi,
I can create an .rdl file and upload it to the report manager page i.e. the default page used... (http://www.sqlservercentral.com/Forums/FindPost416821.aspx)
DEVELOPMENT (http://www.sqlservercentral.com/Forums/Forum145-1.aspx)
GETTING DATA FROM XML USING OPENXML - Hi Guys,
I have the XML file (shown below) and i want to extract the category information.. I want to extract... (http://www.sqlservercentral.com/Forums/FindPost416002.aspx)
REPORTING ON AGGREGATES - Fairly new to non-trivial SQL statements and I have server logs that I have imported and I want to be... (http://www.sqlservercentral.com/Forums/FindPost415682.aspx)
LINK SERVER OLE DB PROBLEM - I created a link server from SQL Server 2000 to FoxPro database using vfpoledb driver. SQL server and FoxPro database... (http://www.sqlservercentral.com/Forums/FindPost411824.aspx)
SQL SERVER 2005 GENERAL DISCUSSION (http://www.sqlservercentral.com/Forums/Forum149-1.aspx)
METADATA STRUCTURE / DESIGN ISSUES - Hi People,
I have been developing an application that needs to store 30 fields of meta data against each item on... (http://www.sqlservercentral.com/Forums/FindPost416843.aspx)
HOW DO I CREATE A FULLTEXT INDEX ON A VIEW? - Hello all,
I'm wanting to do a CONTAINS query on fields that belong to two seperate tables. So, for example, this... (http://www.sqlservercentral.com/Forums/FindPost416840.aspx)
GET LONGEST LENGTH OF DATA IN A COLUMN - I am just curious about some data. I have a column in my table and it is varchar(3000). How can... (http://www.sqlservercentral.com/Forums/FindPost416839.aspx)
ISSUES RUNNING A BACKUP FROM A TRIGGER? - We have a trigger on a table and when the value of a field changes we run a xp_sqlmaint command... (http://www.sqlservercentral.com/Forums/FindPost416811.aspx)
SCRIPTING OUT DB OBJECTS - In SQL 2000 there was an option to script each object to individual files.
I can't find that option in...
(http://www.sqlservercentral.com/Forums/FindPost416779.aspx)
DETAILS OF IN-LINED TABLE-FUNCTION - How to find details of In-lined table-function i.e size used etc.
How to delete it
why it is created???
Im running sql server...
(http://www.sqlservercentral.com/Forums/FindPost416757.aspx)
SCRIPTING VIEWS IN MANAGEMENT STUDIO VS ENTERPRISE MANAGER - Good Morning,
We have upgraded one of our environments from SQL2000 to SQL2005. There are several users (Billing System and Reporting)... (http://www.sqlservercentral.com/Forums/FindPost416553.aspx)
HELP FOR QUERY - On the following store procedure, if the error occurs on the second update statement, does the table be updated?
[u]Store procedure:[/u]
begin...
(http://www.sqlservercentral.com/Forums/FindPost416306.aspx)
IMPORTING SPREADSHEETS WITH SQL SERVER 2005 - Hi,
I am currently importing spreadsheets into SQL Server 2000 using A DTS package, all the spreadsheets import fine until I... (http://www.sqlservercentral.com/Forums/FindPost416055.aspx)
SQL QUERY NEED HELP!!! URGET - STUDENT (sid, sname, sex, age, year, averagegrade)
SCHOOL (dname, numhonours)
PROF (pname, dname)
COURSE (dname, cno, cname)
MAJOR (dname, sid)
CLASS (dname, cno, classno, pname)
ENROLL...
(http://www.sqlservercentral.com/Forums/FindPost415756.aspx)
CONNECTING SQL SERVER 2005 REMOTELY - I have a sql server 2005 remotely, need to connect from client using sql management studio. I am unable to... (http://www.sqlservercentral.com/Forums/FindPost413498.aspx)
SQL SERVER 2005 STRATEGIES (http://www.sqlservercentral.com/Forums/Forum361-1.aspx)
LARGE TABLE SETUP - I have begun a new project involving setting up a new database. This new database basically consists of one main... (http://www.sqlservercentral.com/Forums/FindPost415809.aspx)
UPGRADE EXISTING SQL 2000 CLUSTER TO SQL 2005 - I have an existing multi instance SQL 2000 cluster with 3 nodes. I have each instance running on one of... (http://www.sqlservercentral.com/Forums/FindPost414954.aspx)
POWERFUL DENSE SERVER SUGGESTIONS PLEASE - We're currently running our production SQL Servers on 4U HP DL585s (4x dual-core AMDs). We continue to grow, scaling out... (http://www.sqlservercentral.com/Forums/FindPost414472.aspx)
DATE ENCRYTION - I have this situation where I need to retrieve information for a particular, date or a range of dates. My... (http://www.sqlservercentral.com/Forums/FindPost410960.aspx)
MIGRATE 2000 DATABASE TO 2005 - My manager decided this morning that we are going to take our SQL Server 2000 database and migrate it to... (http://www.sqlservercentral.com/Forums/FindPost345288.aspx)
SQL SERVER EXPRESS (http://www.sqlservercentral.com/Forums/Forum324-1.aspx)
SQL 2005 EXPRESS ON SHARED SERVER - I have looked all over the internet for an answer to this issue. We have one SQL 2005 instance installed... (http://www.sqlservercentral.com/Forums/FindPost416226.aspx)
SQL SERVER 2005 PERFORMANCE TUNING (http://www.sqlservercentral.com/Forums/Forum360-1.aspx)
URGENT: EXTENDED PROCEDURE HANGED...BLOCKING OTHER EXTENDED PROCEDURES TO RUN - There is a extended procedure which got stuck....even though it get killed still in killed/rollback state and stopping other processes...
stuck...
(http://www.sqlservercentral.com/Forums/FindPost416667.aspx)
USING THE -G STARTUP PARAMETER - Has anyone here ever worked with the -g startup parameter? I am troubleshooting issues with Red-Gate's SQL Backup program. The... (http://www.sqlservercentral.com/Forums/FindPost414985.aspx)
TSQL BY DURATION (RESPONSE TIME) - Hi Friends,
my application is getting very slow performance.:D
Because sql server not responding properly in particular case like run some big... (http://www.sqlservercentral.com/Forums/FindPost414298.aspx)
HUGE TABLE - Hi,
I have got situation like that presently my huge table contains around 54 millions records and on daily basis it... (http://www.sqlservercentral.com/Forums/FindPost413816.aspx)
DISK I/O - I'm trying to get the best performance out of SQL2005 on our cluster. I have EMC Symetrix attached storage (via... (http://www.sqlservercentral.com/Forums/FindPost411870.aspx)
SQL SERVER 2005 INTEGRATION SERVICES (http://www.sqlservercentral.com/Forums/Forum148-1.aspx)
PULLING CHINESE CHARACTERS INTO SQL SERVER VIA SSIS/DTS - I am pulling data from China using 2 different methods. In one case, a text file is sent to an... (http://www.sqlservercentral.com/Forums/FindPost416554.aspx)
SSIS MEMORY ALLOCATION - 64 BIT - I am trying to understand if SSIS can be configured to use more memory on a 64 bit machine? I... (http://www.sqlservercentral.com/Forums/FindPost416178.aspx)
LOOKING FOR SEAMLESS MIGRATION OF SSIS PKG - Looking for seamless migration of SSIS pkg. My current design looks like this:
[b]Define 2 config files on server A[/b] (all... (http://www.sqlservercentral.com/Forums/FindPost416135.aspx)
SSIS DIAGRAMS [EXPORTING TO OTHER PROGRAMS] - Can anyone give me any information on the DTS/SSIS diagrams as to where they stored and in what format.
I'm interested...
(http://www.sqlservercentral.com/Forums/FindPost413826.aspx)
T-SQL (SS2K5) (http://www.sqlservercentral.com/Forums/Forum338-1.aspx)
HOW CAN ONE KEEP WRITING TO THE LOG AT MINIMUM? - I saw this QotD where the answer was TRUNCATE TABLE. Then I read a bit more and was amazed that... (http://www.sqlservercentral.com/Forums/FindPost416860.aspx)
UPDATE STATEMENT WITH INCREMENTING NUMBER - Hi,
I am trying to write an update statement that will concatenate 2 fields and add an incrementing number. Something like... (http://www.sqlservercentral.com/Forums/FindPost416683.aspx)
CUSOR HELP - I need to change this cursor to update accounts to remove the letter 'P' in the prefix. This is the... (http://www.sqlservercentral.com/Forums/FindPost416591.aspx)
DYNAMIC VARIABLE DECLARATION TO AVOID CURSORS - Hi All,
To optimize the performance, we did try to avoid and replace certain CURSORS. To avoid CURSORS, most of the... (http://www.sqlservercentral.com/Forums/FindPost416518.aspx)
INSERT DATA FROM XML FILE - I have an XML File that contains a heirarchical set of data. There are 3 sets of data within this... (http://www.sqlservercentral.com/Forums/FindPost416293.aspx)
TEMP TABLE 'VS' TABLE VARIABLE 'VS' CTE. - Hi All,
I wants to clear my concept about Temp Table,
Table Variable & Common Table Expression Concept.
Can anybody please clear me...
(http://www.sqlservercentral.com/Forums/FindPost415829.aspx)
ADMINISTRATION (http://www.sqlservercentral.com/Forums/Forum5-1.aspx)
NEW USER CREATION - Hi,
I am exploring into DBA side.
When I am trying to add user to the database, I am getting the... (http://www.sqlservercentral.com/Forums/FindPost416872.aspx)
TRANSACTIONAL REPLICATION - I managed to create a transactional replication in our two testing servers. Replication Monitor shows 3 items namely : snaphot agent,log... (http://www.sqlservercentral.com/Forums/FindPost416852.aspx)
LARGE TABLE DELETE 105+ MILLION ROWS... - Well I have gotten into the middle of a pleasant situation...we have a MOM db server that the administrator for... (http://www.sqlservercentral.com/Forums/FindPost416687.aspx)
CANNOT GENERATE SSPI CONTEXT - can anyone help with what causes the following error
Run-time error '-2147467259 (80004005)':
cannot generate SSPI context
it happen when i query the...
(http://www.sqlservercentral.com/Forums/FindPost416507.aspx)
EMAILS - I have a store proc which i want to make it as a sql job where in if it returns... (http://www.sqlservercentral.com/Forums/FindPost416464.aspx)
GETTING LOCK ON A NOLOCK STATEMENT - Hi
I have a query running on my production server
SELECT * FROM table1 WITH (NOLOCK).
But I can see that this spid...
(http://www.sqlservercentral.com/Forums/FindPost416275.aspx)
SQL 2000 SP4 => CANNOT RESTORE A DATABASE ACROSS THE NETWORK - When I try to restore a FULL db backup of a 200 GB database across the network I get the... (http://www.sqlservercentral.com/Forums/FindPost416211.aspx)
JOB STEP TYPE PROBLEM - When trying to select the job step type in EM on SQL2000, the only option available in the drop down... (http://www.sqlservercentral.com/Forums/FindPost416062.aspx)
SP_EXECUTE - When I see SQL Statemnet dbcc inputbuffer of a SPID, I am seeing as (sp_execute; 1). What ever SPID I... (http://www.sqlservercentral.com/Forums/FindPost400519.aspx)
MSG 7391 UNABLE TO BEGIN A DISTRIBUTED TRANSACTION - Hi,
I have two servers - On a daily basis Server A Executes a S. Proc on Server B which collects data (selects)... (http://www.sqlservercentral.com/Forums/FindPost366745.aspx)
SQL SERVER 2000 ENTERPRISE MANAGER SNAP-IN MISSING - After running virus cleaning software on my HD, I suddenly find my Enterprise Manager snap-in missing and fail to initialize. Is the MMC erased... (http://www.sqlservercentral.com/Forums/FindPost322164.aspx)
TRACES, TRACES, TRACES... - Since a few days I find messages in the eventviewer about traces:
19030 :
SQL Trace started.
Trace ID = '1'
Login Name = 'sa'
At the...
(http://www.sqlservercentral.com/Forums/FindPost127564.aspx)
BACKUPS (http://www.sqlservercentral.com/Forums/Forum24-1.aspx)
LARGE DB RESTORE, HELP NEEDED - Scenario:
Production database, total 640+GB, one mdf file and 4* 160gb add. files.
This database is backed up once a week... (http://www.sqlservercentral.com/Forums/FindPost413358.aspx)
ARCHIVING / TRUNCATING - Hello,
I could really use someones assistance with trying to archive / truncate a large database I have. Basically I want to... (http://www.sqlservercentral.com/Forums/FindPost412187.aspx)
DATABASE MIGRATION - hi,
Actually, I've planned to move the data from source db to another db. In the source db, nearly 500... (http://www.sqlservercentral.com/Forums/FindPost409872.aspx)
GENERAL (http://www.sqlservercentral.com/Forums/Forum9-1.aspx)
HOW TO STORE AUDIO FILES IN SQL SERVER 2000 - Hi,
Kindly provide solution for ,,,,,,,,,,,
How to store Audio files in SQL Server 2000
regards
pavan
(http://www.sqlservercentral.com/Forums/FindPost416869.aspx)
HOW TO MAKE AUDIT TRIGGER 'CAPTURE' ALL ROWS AFFECTED? - I am working on a trigger for a table I would like to audit. I am quite new to triggers.... (http://www.sqlservercentral.com/Forums/FindPost416634.aspx)
HOW TO CONVERT LOCAL PATH TO NETWORK PATH TO STORE MY SNAPSHOT FILES - hello friends,
i am trying to develop replication application using C# & .net 2005 with SQL 2005.
i managed to setup replicaition using... (http://www.sqlservercentral.com/Forums/FindPost416397.aspx)
COMMAND LINE ZIP UTILITY? - Scenario is this..I need to regular refreshes of a TEST system which is close to 60 gigs of databases across... (http://www.sqlservercentral.com/Forums/FindPost409693.aspx)
FULL TEXT FILE LOCATION - BEST PRACTICES - Any suggestions and/or supporting documentation for best practices on where to locate the full text catalog files. Especially as related... (http://www.sqlservercentral.com/Forums/FindPost300927.aspx)
GLOBALIZATION (http://www.sqlservercentral.com/Forums/Forum230-1.aspx)
SQL COLLATION AND SYMBOL CHARACTERS - I have a database with Chinese_PRC_CI_AS collation. A varchar column (say ColumnA) in a table. When trying to insert [b]'Shim... (http://www.sqlservercentral.com/Forums/FindPost416890.aspx)
STRATEGIES (http://www.sqlservercentral.com/Forums/Forum49-1.aspx)
NO BUSINESS LOGIC IN THE DATA LAYER.... - I have an interesting position at present in a small firm that is growing fast. The IT Development Team are... (http://www.sqlservercentral.com/Forums/FindPost414851.aspx)
N-HIBERNATE AND DYNAMIC SQL - DBA VS DEVELOPERS - I'm currently working with a development team that are trying to implement n-hibernate as a design tool to speed up... (http://www.sqlservercentral.com/Forums/FindPost375196.aspx)
SQL SERVER NEWBIES (http://www.sqlservercentral.com/Forums/Forum169-1.aspx)
INSERT QUERY - Hello!
Using ASP, with the RecordSet Object (objRS), I have a question
When running the following query:
"SELECT something FROM table"
To get the...
(http://www.sqlservercentral.com/Forums/FindPost416844.aspx)
STANDBY / TRN LOG SHIPPING - FEW QUESTIONS - Hello
Environment : SQL Server 2005 CE , Win 2003
I am new to SQL Server and has currently set up a (Production)... (http://www.sqlservercentral.com/Forums/FindPost414714.aspx)
RECURSIVE QUERY FOR A BILL OF MATERIALS TABLE - Hi people,
I could really do with a bit of help here. I have a table in the following format:
StockCode1, StockCode2
StockCode1,...
(http://www.sqlservercentral.com/Forums/FindPost414386.aspx)
PERFORMANCE TUNING (http://www.sqlservercentral.com/Forums/Forum65-1.aspx)
POOR PERFORMANCE - Hi all,
I have a SQL Server 2000 standard edition instance running on Windows 2000 SP4 with 2Gb of memory. The... (http://www.sqlservercentral.com/Forums/FindPost415292.aspx)
T-SQL (http://www.sqlservercentral.com/Forums/Forum8-1.aspx)
VARCHAR DEFAULT LENGTH - Hi Experts,
I am very confused about the default length for varchar datatype. I was read an article in our sqlservercentral.com... (http://www.sqlservercentral.com/Forums/FindPost416897.aspx)
DIFFERENCE BETWEEN CLIENT CURSOR AND SERVER CURSOR - Hi Experts,;)
I want to know the difference between client cursor and server cursor.Where exactly the server side cursor is used... (http://www.sqlservercentral.com/Forums/FindPost416894.aspx)
DYNAMIC INDEX - Hi all,
I have a problem with my Stored Procedure. It runs longtime. How can i create Dynamic index for... (http://www.sqlservercentral.com/Forums/FindPost416891.aspx)
MISSING SEQUENCE - SQL2000 A table contains ID, CODE, and PRIORITY(varchar). For each ID Exists codes prioritized 1..n. Example :(ID, Code, PRI)
1 , A1, 01
1...
(http://www.sqlservercentral.com/Forums/FindPost416695.aspx)
RETRIEVE THE DST PATCH UPDATED DATE IN SQLSERVER 2000? - Hello all,
Hope all of us know that DST Patch update will be on 4th November,07.
Here my query is how...
(http://www.sqlservercentral.com/Forums/FindPost416457.aspx)
HOW TO REMOVE NUMBERS FROM STRINGS? - hello,
i have a question:
i have a string and i need to remove the numbers from it. something like oracle's... (http://www.sqlservercentral.com/Forums/FindPost411775.aspx)
SQL SERVER AGENT (http://www.sqlservercentral.com/Forums/Forum110-1.aspx)
HOW TO CONNECT TO SQL SEVER 2K RUNNING IN WIN2K SERVER MACHINE - hello everybody
i am pretty new to sql server and msde2000 our server has sql server 2k and the client... (http://www.sqlservercentral.com/Forums/FindPost416309.aspx)
CERTIFICATION (http://www.sqlservercentral.com/Forums/Forum10-1.aspx)
BUSINESS INTELLIGENCE DEVELOPER CERTIFICATION - Hello,
I'm interested in obtaining Microsoft's "[url=http://www.microsoft.com/learning/mcp/mcitp/bid/default.mspx]Business Intelligence Developer[/url]" certification.
In order to obtain the certification one must pass both... (http://www.sqlservercentral.com/Forums/FindPost406505.aspx)
SQLSERVERCENTRAL.COM WEBSITE UPGRADE (http://www.sqlservercentral.com/Forums/Forum433-1.aspx)
WHERE IS THE ARTICLE - I was navigating through articles and got to this
http://www.sqlservercentral.com/articles/Basics/20010422115709/78/
But where is the article? All I can see is the introduction. (http://www.sqlservercentral.com/Forums/FindPost416893.aspx)
SUGGESTIONS (http://www.sqlservercentral.com/Forums/Forum4-1.aspx)
EDITING A POST - Steve,
Just an FYI. If you post, then choose "Edit Post" after submitting the original, while you're in edit mode, the... (http://www.sqlservercentral.com/Forums/FindPost415152.aspx)
WHAT IS THE BEST MEATHOD OF IMPORTING EXCEL FILES. - hi everybody,
I am maintaining a system which is importing CSV files into SQL Server. we use BULK insert from a... (http://www.sqlservercentral.com/Forums/FindPost188184.aspx)
REPORTING SERVICES (http://www.sqlservercentral.com/Forums/Forum150-1.aspx)
REPORT STATEMENTS - I have a report that is basically a statement (invoice) The report has a list which is based on the... (http://www.sqlservercentral.com/Forums/FindPost416608.aspx)
FILTER DROPDOWN DOES NOT POPULATE IN REPORT BUILDER - We're using SQL 2005 Reporting Services. The Reporting Services is configured to use Integrated Windows Authentication in IIS.
The problem is...
(http://www.sqlservercentral.com/Forums/FindPost414617.aspx)
ORA-12154 TNS COULD NOT RESOLVE SERVICE NAME WHEN TESTING ORACLE DATA SOURCE - Hello,
I am trying to use SQL Server 2005 Reporting Services to access an Oracle 8i database. I can access the... (http://www.sqlservercentral.com/Forums/FindPost330866.aspx)
ADMINISTRATION (http://www.sqlservercentral.com/Forums/Forum162-1.aspx)
REPORT MANAGER ERROR NEED HELP - Hi, I have a sql server 2005 on a windows 2000 machine. I installed sql server 2005 but when I... (http://www.sqlservercentral.com/Forums/FindPost416846.aspx)
STRATEGIES AND IDEAS (http://www.sqlservercentral.com/Forums/Forum363-1.aspx)
IN SEARCH FOR GOOD READING MATERIAL ABOUT DW DESIGN - Good day all,
I'm searching for any good books/white papers/articals about designing data warehouses. I've found a couple of books, but... (http://www.sqlservercentral.com/Forums/FindPost416356.aspx)
DATAWAREHOUSE, "LARGE" INSERTS, MEMORY USAGE - We are developing our first datawarehouse. When running a developer query (an INSERT of a modest dataset, 4 millions rows) the DW... (http://www.sqlservercentral.com/Forums/FindPost374996.aspx)
DATA TRANSFORMATION SERVICES (DTS) (http://www.sqlservercentral.com/Forums/Forum19-1.aspx)
WORKING WITH MULTIPLE FLAT FILES - Hello,
We have a system that, on a daily basis, produces a flat file of fixed width records from a mainframe.... (http://www.sqlservercentral.com/Forums/FindPost320512.aspx)
MICROSOFT ACCESS (http://www.sqlservercentral.com/Forums/Forum131-1.aspx)
MATCHING THE DUPLICATE RECORDS AND DOING A COUNT HELP? - The code below is the query .
what im trying to do is to get all the personnelNumbers that occur greater... (http://www.sqlservercentral.com/Forums/FindPost415910.aspx)
|
|