EDITORIAL - NOT JUST AT HOME
ADVERTISEMENT
-->Free Book Offer.Sign up for the End to End Training monthly mailing list and receive a free print copy of Two Minute SQL Server Stumpers Volume One - a $24.99 value. We even pay the shipping cost. US residents only please.
-->SSIS Training by Brian Knight. Learn SSIS from the guy who wrote the books on it. Whether you're a beginner or intermediate SSIS user, this class will move you into the ranks of the power user. 4 day class is $2400 and includes a copy of his latest book, Expert SQL Server 2005 Integration Services.
-->Celko on SQL in Orlando. This is a one day seminar presented by Joe Celko, author of six books, hundreds of articles, thousands of forum posts, and a member of the of the ANSI committee that wrote the SQL-89/92 standards. If you want to really be a SQL power user you need to spend some time with Joe and his sometimes mind bending approaches to how the SQL language is correctly used. Use promo code 'SSC' prior to Oct 15th, 2007 to register for only $149.
-->SSIS Stumper Vol 1. Register for our monthly End to End Training Newsletter and you can download a really cool SSIS puzzle to solve. No better way to increase your skills than working on a good challenging problem!
FEATURED ARTICLES
DEADLOCK NOTIFICATIONS IN SQL SERVER 2005 Deadlocks do not occur too often, but when they do, it can be a time consuming and frustrating endeavor to track them down. In SQL Server 2000, you could alter the message to ensure these were written to the error log and track them down quickly. In SQL Server 2005, it is a little more tricky, but new author Patrick Leblanc brings us a technique for sending out a notification. http://www.sqlservercentral.com/links/375023/4417
SQL SERVER 2005 EXPRESS EDITION - PART 5 - POST-INSTALLATION NETWORK CONFIGURATION TASKS In this article, we will continue exploring other post-setup tasks, focusing on network specific tasks. http://www.sqlservercentral.com/links/375023/4419
PIPELINE MEMORY LIMITER
Backpressure is an interesting internal memory limiter inside SSIS and in SQL Server 2008 you get to see when the limiter kicks in.
http://www.sqlservercentral.com/links/375023/4421
QUESTION OF THE DAY - HOW CAN YOU REMOVE THE FILTER CREATED BY...
YESTERDAY'S QUESTION OF THE DAY - WHAT IS THE REGISTRY KEY TO CHECK TO...
Today's Question is sponsored by: Pro SQL Server 2005 High Availability by Allan Hirt
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.
FEATURED SCRIPT
DATABASE PROS WHO NEED YOUR HELP!
ADMINISTERING (http://www.sqlservercentral.com/Forums/Forum146-1.aspx)
NO HITS IN LOCAL HELP SEARCH ANYMORE - Hi!
After installing the May 2007 version of the SQL Server Books online (German language) the full text search in the... (http://www.sqlservercentral.com/Forums/FindPost408327.aspx)
UPGRADE SQL 2005 DEVELOPERS TO ENTERPRISE EDITION - We have a default instance of SQL 2005 Developers Edition that we want to upgrade to SQL 2005 Enterprise Edition.... (http://www.sqlservercentral.com/Forums/FindPost408142.aspx)
DATABASE MAIL NOT SENDING MESSAGES - I have a Server that doesn't seem to always send email. The messages will get queued like they're supposed to... (http://www.sqlservercentral.com/Forums/FindPost408062.aspx)
MAKE OWN PC A "SERVER" - Hi,
First post!
I have installed SQL Server Ent Console on my PC. In Ent Mgr, how do I register my own... (http://www.sqlservercentral.com/Forums/FindPost408025.aspx)
SERVER NAME - On starting a new job I have discovered that a number of databases seem to have been installed before the... (http://www.sqlservercentral.com/Forums/FindPost408014.aspx)
COMPATIBILITY MODE IN SQL SERVER 2005 - A customer has asked me if my product is compatible with SQL Server
2005 running in 8.0 Compatibility Mode.
What does he...
(http://www.sqlservercentral.com/Forums/FindPost407783.aspx)
O/S PARTITION - Hello,
I have RAID 5 and total size 1000 GB.?
I created 3 partitions :
C drive (O/S only)
E drive (SQL Server...
(http://www.sqlservercentral.com/Forums/FindPost407566.aspx)
64BIT MICROSOFT OLEDB DRIVER FOR ORACLE? WHERE IS THE DOWNLOAD?? - i know it's installed automatically; but if thats the case why don't i see it
in my providers list??
Management Studio\Server Objects\Linked... (http://www.sqlservercentral.com/Forums/FindPost407055.aspx)
SQL SERVER 2K5 PROFILER FILTER DOENS'T SEEM TO WORK - Hi everyone,
We have a table in SQL 2K5 that mysteriosuly gets data deleted from every so often.
I wanted to capture...
(http://www.sqlservercentral.com/Forums/FindPost407042.aspx)
USER PERMISSION & PRIVILEGE ISSUE SQL SERVER 2005 - Due to policy, i cannot take out 'SA' roles for other 3 users. i am getting lot of complaints that... (http://www.sqlservercentral.com/Forums/FindPost407027.aspx)
MAIL WORKS, BUT NOT FROM JOB NOTIFICATION - I cannot seem to get a scheduled job to notify me by email when it completes. I set up mail,... (http://www.sqlservercentral.com/Forums/FindPost406836.aspx)
O/S PARTITION - Hello....I have 1200 GB drive space RAID 5.
Can anyone recommand the size for best practice to create these partitions.?
C...
(http://www.sqlservercentral.com/Forums/FindPost403476.aspx)
LINKED SERVER ERROR: CANNOT OBTAIN THE SCHEMA ROWSET "DBSCHEMA_CATALOGS" - I am trying to create a linked server using a Teradata ODBC DSN in SQL 2005. When I create the... (http://www.sqlservercentral.com/Forums/FindPost375700.aspx)
SP_DEFRAGMENT_INDEXES NOT WORKING IN 2005 - Hello!
As a novice with regard to SQL, I am doing what I can to make my Maintenance Plans and backups... (http://www.sqlservercentral.com/Forums/FindPost342884.aspx)
BACKUPS (http://www.sqlservercentral.com/Forums/Forum357-1.aspx)
RESTORING A LOCAL DATABASE BACKUP ONTO A REMOTE HOST - Hello,
I've created an mssql datbase on localhost and purchased some webspace with mssql support.
I've used the 'backup' option...
(http://www.sqlservercentral.com/Forums/FindPost407771.aspx)
BUSINESS INTELLIGENCE (http://www.sqlservercentral.com/Forums/Forum147-1.aspx)
SETTING PROPERTY OF TEXT BOX FOR TEXTDECORATION - Hi,
I am using SSRS where I came across one text box what I want from it is..its string is "Employee... (http://www.sqlservercentral.com/Forums/FindPost407974.aspx)
WHAT HAPPENED TO PROCLARITY - Hi,
I heard that Microsoft purchased the company, but could not find where the latest Proclarity client belongs to. Is it... (http://www.sqlservercentral.com/Forums/FindPost407822.aspx)
DATA WAREHOUSE DATABASES / SCHEMAS / FILES AND FILEGROUPS - I currently have a dimensional database which contains data for specific part of the company. Now we are developing a... (http://www.sqlservercentral.com/Forums/FindPost407493.aspx)
DATA CORRUPTION (http://www.sqlservercentral.com/Forums/Forum266-1.aspx)
HOW TO PUT DATABASE IN SINGLE USER MODE WHILE DBCC CHECKDB? - I am trying to repair database by dbcc checkdb with repiar_fast, but it ask me to keep database in single... (http://www.sqlservercentral.com/Forums/FindPost405557.aspx)
DEVELOPMENT (http://www.sqlservercentral.com/Forums/Forum145-1.aspx)
DBCC SHOWCONTIG RETURNS 0 PAGES SCANNED - I have a table in SQL Server 2005 DB which has about 650 million records. When I run a DBCC... (http://www.sqlservercentral.com/Forums/FindPost408111.aspx)
GETTING ALLOW NULLS INFORMATION - I am comparing two databases. When a field is missing from one I generate it in the other. In Delphi... (http://www.sqlservercentral.com/Forums/FindPost407903.aspx)
CREATE AN ORDER - How do you fill out an order form?
there is an Order(OrderID, CustomerID, Subtotal, Tax, Total), Orderdetail(OrderID, ProductID, Qty, UnitPrice, ExtendedPrice)
How...
(http://www.sqlservercentral.com/Forums/FindPost407563.aspx)
STANDARDIZING PRIMARY KEYS - I have already designed a database in SQL Server 2005.But I just want some advices on better way of standardizing... (http://www.sqlservercentral.com/Forums/FindPost381838.aspx)
SQL SERVER 2005 GENERAL DISCUSSION (http://www.sqlservercentral.com/Forums/Forum149-1.aspx)
LOOKUP TABLE OPTIONS - HI All,
I was wondering if someone could answer my question about designing tables with integers that represent bit values.
I think...
(http://www.sqlservercentral.com/Forums/FindPost408322.aspx)
COMPLEX COUNT/SUM - Hi All,
I have a race results database with about 15 tables. I need to count and sum the values in... (http://www.sqlservercentral.com/Forums/FindPost408291.aspx)
EXPRESS AND SQL2005 - I have SQLExpress installed on local box along with VS2005. I then attempted to install SQL2005 components (SSMS, BOL, etc..)... (http://www.sqlservercentral.com/Forums/FindPost408221.aspx)
UPGRADE SQL 2005 WORKGROUP? - Is it possible to upgrade SQL 2005 Workgroup to SQL 2005 Standard?
Thanks
Ron K.
www.mycarstats.com
:)
(http://www.sqlservercentral.com/Forums/FindPost408126.aspx)
UNABLE TO INSTALL SQL SERVER 2005 - "REMOVING BACKUP FILES" HANGS - HELP! For the past several weeks, I have been trying to install SQL Server 2005 on a Win XP SP2... (http://www.sqlservercentral.com/Forums/FindPost407955.aspx)
CONNECTION PROBLEMS - Hi there,
Previously SQL2005 was running fine on my machine and I usually leave my machine on at all times.
When I...
(http://www.sqlservercentral.com/Forums/FindPost407904.aspx)
ANOTHER PIVOT OR TRANSPOSE QUESTION - I have done some research on this and come up with nada. Given this table:
[code]LastName Qty
Smith 25
Jones 19
Baker 4
Ford 11
Etc....
[/code]
I...
(http://www.sqlservercentral.com/Forums/FindPost407562.aspx)
REMOTE CONNECTIVITY/STANDARD EDITION - I am an intern with no previous experience with SQL Server. I have 2005 standard edition that i installed onto... (http://www.sqlservercentral.com/Forums/FindPost407019.aspx)
DEVELOPER - BEST LAPTOP SETUP - I work for a non-profit and a window of opportunity to obtain a laptop has finally opened up! :D
I will...
(http://www.sqlservercentral.com/Forums/FindPost406964.aspx)
SQL SERVER 2005 SECURITY (http://www.sqlservercentral.com/Forums/Forum359-1.aspx)
SYSADMIN ROLE LOCKED - We set up a SQL Server 2005 box. When we set it up we did it with windows authentication, so... (http://www.sqlservercentral.com/Forums/FindPost407321.aspx)
ACCESS PERMISSION ISSUES IN SQL SERVER 2005 - In our ASP.NET application, we are using windows authentication to connect to the SQL Server.
Most of the stored procedures...
(http://www.sqlservercentral.com/Forums/FindPost406946.aspx)
WHAT ROLES SHOULD THEY BE GIVEN? - Hi,
our web application admins need to manage all the exisiting web databases and also need to create databases from time... (http://www.sqlservercentral.com/Forums/FindPost406580.aspx)
SQL SERVER 2005 STRATEGIES (http://www.sqlservercentral.com/Forums/Forum361-1.aspx)
ROBUST DATA LOAD PROCESS - I am seeking further information for strategies/best parctices on building a robust control process to co-ordinate multiple data load processes.
To...
(http://www.sqlservercentral.com/Forums/FindPost405890.aspx)
SS2K5 REPLICATION (http://www.sqlservercentral.com/Forums/Forum291-1.aspx)
HOW TO SHRINK A DISTRIBUTION DATABASE IN SQL 2005 PEER-TO-PEER REPLICATION ENVIRONMENT?? - Hi
I got Peer-to-Peer Replication configured and running on SQL Server 2005 EE + SP2 on Windows 2003 R2 + SP1 platform.
Total number...
(http://www.sqlservercentral.com/Forums/FindPost407384.aspx)
TRANSACTIONAL REPLICATION: QUERY TIMEOUT EXPIRED. - Hi
we have a transactional Replication between two 2K5 SQL Servers in our production with about 1-4 Mio I/O's per Day.... (http://www.sqlservercentral.com/Forums/FindPost406959.aspx)
SQL SERVER EXPRESS (http://www.sqlservercentral.com/Forums/Forum324-1.aspx)
UNABLE TO CONNECT TO SQL SERVER 2005 EXPRESS - Hi, all.
I installed SQL Server 2005 Express edition with Advanced Services about 4 months ago. I named instance GORAN-\SQLEXPRESS (GORAN-... (http://www.sqlservercentral.com/Forums/FindPost407768.aspx)
PUTTING IMAGE FILES IN SQL SERVER 2005 - Hi all,
I posted to this forum recently, and I have one more question.
I worked for 3 years in a church...
(http://www.sqlservercentral.com/Forums/FindPost407676.aspx)
SQL SERVER 2005 PERFORMANCE TUNING (http://www.sqlservercentral.com/Forums/Forum360-1.aspx)
HOW DO I PLACE MY FILES IN SAN ENV? - [size="3"]Hi,
We have a database which is around 120 GB and growing rapidly around a GB per week.
Currently we have an...
(http://www.sqlservercentral.com/Forums/FindPost408293.aspx)
OPTIMIZING SQL SYSTEM STORED PROCEDURES - WHAT'S IN A SELECT? - Hoping this trickles back to the lair of the Architect...
One of the most disparaging things I run across in SQL... (http://www.sqlservercentral.com/Forums/FindPost407636.aspx)
DATAPUMP IS VERRRRRY SLOW - I'm neither a systems person nor DBA, so please bear with me, if I don't explain this quite right.
I'm running...
(http://www.sqlservercentral.com/Forums/FindPost407575.aspx)
SQL QUERY TUNING - Â Please help me in giving the suggestions for tuning the below query. The execution time is 12 min.
Below is the...
(http://www.sqlservercentral.com/Forums/FindPost400533.aspx)
SQL SERVER 2005 INTEGRATION SERVICES (http://www.sqlservercentral.com/Forums/Forum148-1.aspx)
SSIS FILE HANDLING - Hi,
I am writing a package that deals with file handling. After processing a file, I am to write the name... (http://www.sqlservercentral.com/Forums/FindPost408251.aspx)
DYNAMIC COLUMN MAPPING - Is there a way to dynamically update the column mappings of an OLE DB Destination Connection to the columns of... (http://www.sqlservercentral.com/Forums/FindPost408211.aspx)
MIGRATING DTS PACKAGES TO SSIS - [font="Comic Sans MS"]Hi all,
Can any body tell me how to migrate SQL Server 2000 DTS packages to SSIS, i am... (http://www.sqlservercentral.com/Forums/FindPost407985.aspx)
SSIS IN CLUSTERED ENVIRONMENT - Hi,
[I posted this topic in the "Administering" forum originally and figured I should post it here as well.]
I have SQL...
(http://www.sqlservercentral.com/Forums/FindPost405737.aspx)
LOGGING IN SSIS - how to create log detail for each task in ssis. for example
in data transfer i need to get how many... (http://www.sqlservercentral.com/Forums/FindPost404160.aspx)
FILE SYSTEM TASK VARIABLE - I have a file system task that copys an excel spreadhseet and renames it to a different file name. Sounds... (http://www.sqlservercentral.com/Forums/FindPost274245.aspx)
T-SQL (SS2K5) (http://www.sqlservercentral.com/Forums/Forum338-1.aspx)
SP EXECUTION PROBLEM IN SQL - Hi there,
i have a stored procedure and many parameters. i want to use "exec sp_name" and give some parameters of... (http://www.sqlservercentral.com/Forums/FindPost408299.aspx)
FIND SUB-TREE NODES - Hi,
I have a tree structure represented by a simple table that references itself:
[code]
CREATE TABLE [dbo].[AframeGroup] (
[GroupID] [int] IDENTITY (1, 1)...
(http://www.sqlservercentral.com/Forums/FindPost408290.aspx)
THE USE COMMAND - Hi all
I was wondering, in the light of SS2K5 now supporting the use of variable in SELECT TOP statements, does... (http://www.sqlservercentral.com/Forums/FindPost408101.aspx)
DATE FORMATTING ISSUE - Hi,
I'm running SQL Server 2005. The installation is set to use the dd/mm/yyyy (British date format). I have a database... (http://www.sqlservercentral.com/Forums/FindPost408081.aspx)
MANIPULATING INTEGER8 (ACTIVE DIRECTORY) - Greetings.
I want to query Active Directory from SQL Management Studio Express. As you can see, I need to get Integer8... (http://www.sqlservercentral.com/Forums/FindPost407624.aspx)
QUERY FOR DISPALY ROWS VALUE IN COLUMN WISE - Hi everyone
I have two table
Table1
id date 101 10/01/2007 102 10/04/2007 103 10/05/2007 104 10/06/2007
Table 2
id Plan
101 A
101 B
102 A
102 B
102 C
102 D
103 C
103...
(http://www.sqlservercentral.com/Forums/FindPost407185.aspx)
COMPLEX SELECT PROBLEM W HISTORY TABLES, DATE RANGES - I working on a mobile/cell phone database. Unlike in the original db I will use english column names here for... (http://www.sqlservercentral.com/Forums/FindPost406659.aspx)
CONVERT 2005 TABLE VALUED FUNCTION TO 2000 - Hi there, I have a table valued function writen in 2005 which I can join to using CROSS APPLY.
I ned...
(http://www.sqlservercentral.com/Forums/FindPost405463.aspx)
REMOVE DECIMALS WITHOUT ROUNDING - How do I take a number like maybe 10.73 and remove the decimal place and making it a number like... (http://www.sqlservercentral.com/Forums/FindPost403180.aspx)
ADMINISTRATION (http://www.sqlservercentral.com/Forums/Forum5-1.aspx)
SHOULD WE ALLOW NEW CONNECTION TO THE SQL SERVER WHILE THE REINDEXING (DBCC DBREINDEX) IS IN PROGRESS? - Hi All,
Our company is doing monthly reboot activity and our infrastructure team is asking whether they are allowed to start... (http://www.sqlservercentral.com/Forums/FindPost408325.aspx)
SHEDULING PAKAGES AS JOB FAILS - Hi,
Can you help how to solve this error.
When I am sheduling pakages to run as job.
I am getting the error...
(http://www.sqlservercentral.com/Forums/FindPost408279.aspx)
UPDATE ALL EMPTY CELLS TO NULL? - Hi,
Is it possible to do an update to a table that sets all empty cells to a NULL value? By... (http://www.sqlservercentral.com/Forums/FindPost408170.aspx)
SQL SERVER 2000 SLOW RESPONSE TIME - Hello,
I am a VB programmer and all of a sudden all the DBA's in my company have resigned.
I have...
(http://www.sqlservercentral.com/Forums/FindPost407957.aspx)
TRACE TABLE USAGE ON SQL 2000 - Hi,
We've got a SQL 2000 databases with +- 3000 tables on them. Some of these tables were created by previous DBA's... (http://www.sqlservercentral.com/Forums/FindPost407238.aspx)
CLUSTER FAILOVER NOT HAPPENING..PLSE HELP - Hi
I have installed the SQL 2000 cluster with the SP4 and hotfix for awe and working fine for few hours,... (http://www.sqlservercentral.com/Forums/FindPost399853.aspx)
COULD NOT ALLOCATE SPACE FOR OBJECT, THE ''PRIMARY'' FILEGROUP IS FULL. - SQL 2000 SP4 EventID 17052:
Error: 1105, Severity: 17, State: 2
Could not allocate space for object 'tblInventoryCT' in database 'Eicon' because the... (http://www.sqlservercentral.com/Forums/FindPost242179.aspx)
SSL SECURITY ERROR - I am trying to connect to SQL Server 2000Â and I am getting the following error.
" A connect could not be...
(http://www.sqlservercentral.com/Forums/FindPost210338.aspx)
TROUBLE RUNNING SQLH2 - I am trying to install the "SQL Server Health and History Tool (SQLH2)". The Setup creates a database to store... (http://www.sqlservercentral.com/Forums/FindPost175670.aspx)
GENERAL (http://www.sqlservercentral.com/Forums/Forum9-1.aspx)
SP_SQLSMTPMAIL UP AND DIED ON US - Hi... We have been using sp_SQLSMTPMail as found on this site to be able to send emails from all of... (http://www.sqlservercentral.com/Forums/FindPost329990.aspx)
SECURITY (http://www.sqlservercentral.com/Forums/Forum6-1.aspx)
PERMISSIONS ISSUE SQL 2000 - Using the pub database through an odbc link to access i have full access to the authors table, view, delete,... (http://www.sqlservercentral.com/Forums/FindPost404006.aspx)
HOW DO YOU KNOW WHO IS LOGGED IN FROM A WINDOWS GROUP? - Is it possible to find the individual logon of someone who has being granted access via a windows group logon.... (http://www.sqlservercentral.com/Forums/FindPost403058.aspx)
STRATEGIES (http://www.sqlservercentral.com/Forums/Forum49-1.aspx)
LOOKUP OR REFERENCE TABLES - I am in the process of designing my database for an upcoming project. I have the following situation that I... (http://www.sqlservercentral.com/Forums/FindPost408095.aspx)
PERFORMANCE TUNING (http://www.sqlservercentral.com/Forums/Forum65-1.aspx)
SHEDULE JOB FAIL'S IN SQL 2000 - Hi,
Can you help how to solve this error.
When I am sheduling pakages to run as job.
I am getting the error...
(http://www.sqlservercentral.com/Forums/FindPost408274.aspx)
QUESTION ABOUT SQL SERVER MAX MEMORY CONFIGURATION - Hello,
I posted this at sql-server-performance.com (where I found good information on SQL performance audits) but thought I should post it... (http://www.sqlservercentral.com/Forums/FindPost407623.aspx)
BUFFER CACHE HIT RATIO = 0 - Hey Everyone,
I have a single machine running SQL Server 2000 (8.00.2039) on Windows 2003 SP2.
I have been running system monitor...
(http://www.sqlservercentral.com/Forums/FindPost407523.aspx)
DAY MONTH YEAR D.B. FIELDS VS YMD FIELD USING DATE FUNCTIONS - Please provide some general guidlines on whether it is better to represent in a D.B. a fields for Year, Month,... (http://www.sqlservercentral.com/Forums/FindPost404180.aspx)
LINKED SERVER "DATA PULL" VS "DATA PUSH" - Hi,
I'm a self taught developer using SQL Server 2000 and 2005. At present my employer is doing a project which... (http://www.sqlservercentral.com/Forums/FindPost403063.aspx)
T-SQL (http://www.sqlservercentral.com/Forums/Forum8-1.aspx)
STORED PROCEDURES FLEXIBILITY - Hello All,
As I am not a T-SQL developer, I want some help on stored procedures.
In many cases it is needed...
(http://www.sqlservercentral.com/Forums/FindPost408328.aspx)
UPDATE ORDER AND MAXDOP - I try to use Update Statement in situations that I need field values from previous record.
This approach have much more...
(http://www.sqlservercentral.com/Forums/FindPost408207.aspx)
INSERT FROM 1 TABLE INTO MASTER- DETAIL TABLES - Hello,
I have a table with order information (name, shipping info,item qty etc...) in one table.
I need to insert this info...
(http://www.sqlservercentral.com/Forums/FindPost408021.aspx)
MULTIPLE COUNTS IN A ROW - I want to display three different counts in a single row. Any clues on the select statement.
Must look something...
(http://www.sqlservercentral.com/Forums/FindPost407772.aspx)
AVERAGES AND MEDIANS WITHOUT A CUBE - So I've got this nice little report that extracts data from my database and shows a particular set of data... (http://www.sqlservercentral.com/Forums/FindPost407481.aspx)
RETURN STATEMENT PROPER USE - I am looking for some clarity on the proper use of a Return Statement. As I understand things a Return... (http://www.sqlservercentral.com/Forums/FindPost407332.aspx)
BANKER''S ROUNDING IN T-SQL (LIKE MATH.ROUND IN .NET) - Hi!
I'm in extreme need of T-SQL function wich will round to the nearest even number, called banker's rounding or rounding... (http://www.sqlservercentral.com/Forums/FindPost246556.aspx)
RETRIVING HOST IP ADDRESS VIA T-SQL - Guys/Gal,
I need help, I am going nuts... I am trying to find a query which will retrieve the IP-Address of... (http://www.sqlservercentral.com/Forums/FindPost150196.aspx)
EMPLOYERS AND EMPLOYEES (http://www.sqlservercentral.com/Forums/Forum334-1.aspx)
HOW COME NO ONE POST ANY JOB? - Before the change, there were a lot of job posting, now it seemed no one posting jobs.:unsure: Was something wrong... (http://www.sqlservercentral.com/Forums/FindPost406966.aspx)
GENERAL (http://www.sqlservercentral.com/Forums/Forum23-1.aspx)
BETTER WAY TO WRITE? - Greetings,
So the stupid question of the moment is how can I make this work without doing the select statement the... (http://www.sqlservercentral.com/Forums/FindPost407559.aspx)
''GRAND TOTAL'' ON CTE/PIVOT RESULTS? - Greetings,
I haven't found a particular example but I was wondering if it was possible to get a 'grand total' column... (http://www.sqlservercentral.com/Forums/FindPost389405.aspx)
ANYTHING THAT IS NOT ABOUT SQL! (http://www.sqlservercentral.com/Forums/Forum61-1.aspx)
HELP PLEASE - Hi
I have recently changed employment. Hence my email address has changed. My former email address is used as my login... (http://www.sqlservercentral.com/Forums/FindPost405808.aspx)
I JUST WANT TO DO MY JOB ! - It seemed for the past couple years, I had a lot of problems with my job mostly because of
'people'....
(http://www.sqlservercentral.com/Forums/FindPost404515.aspx)
SQLSERVERCENTRAL.COM WEBSITE UPGRADE (http://www.sqlservercentral.com/Forums/Forum433-1.aspx)
CANNOT VIEW DISCUSSION OF OLD ARTICLES - Before the site makeover I believe that I was able to read through the discussions of articles, no matter how... (http://www.sqlservercentral.com/Forums/FindPost408281.aspx)
ANNOYANCE - SPELL CHECK - I tried the spell check for the first time today. Apparently I really can't speel because the tags, the if... (http://www.sqlservercentral.com/Forums/FindPost406891.aspx)
"MY RECENT POSTS" - CAN NOT FIND - I used "My Recent Posts" to check if I replied to and others replied to me at the topics I... (http://www.sqlservercentral.com/Forums/FindPost405169.aspx)
REPORTING SERVICES (http://www.sqlservercentral.com/Forums/Forum150-1.aspx)
PROBLEM SUPRESSING A LINE IN REPORTING SERVICES. - Hi !
I am working on Coverting existing Crystal reports to Reporting Services. Now I have a line in Crystal reports... (http://www.sqlservercentral.com/Forums/FindPost407117.aspx)
GENERATING MULTIPLE OUTPUT FILES - I'd like to provide a user with a report where he enters a couple of parameters, hits go, and this... (http://www.sqlservercentral.com/Forums/FindPost406095.aspx)
TROUBLE SHOOTING OF THE ''SELECT ALL'' PARAMETER - Hi
When we use a report where in the parameter several possibilities shoud be available we want to use teh Select... (http://www.sqlservercentral.com/Forums/FindPost388872.aspx)
DESIGN IDEAS AND QUESTIONS (http://www.sqlservercentral.com/Forums/Forum373-1.aspx)
DESIGNEN A DATA WAREHOUSE WITH A LARGE AMOUNT OF DATA. - Hello Folks,
Im currently starting up a data warehouse project. This DW will placed at customer whos in the retail business,... (http://www.sqlservercentral.com/Forums/FindPost405660.aspx)
ANALYSIS SERVICES (http://www.sqlservercentral.com/Forums/Forum17-1.aspx)
ANALYSIS SERVICES QUESTION - Hi, I am new to sql analysis services and learning the cubes.
Here is my question, How do I select the primary... (http://www.sqlservercentral.com/Forums/FindPost394843.aspx)
DATA TRANSFORMATION SERVICES (DTS) (http://www.sqlservercentral.com/Forums/Forum19-1.aspx)
ERROR: FAILING ROWS EXCEEDS MAX SPECIFIED - Source: SQL Server 2K (Win2k)
Tool: DTS
Destination: DB2 (Linux)
Error Source: Data Pump
Error Message: The failing rows exceeds the maximum specified
Error Code:...
(http://www.sqlservercentral.com/Forums/FindPost268083.aspx)
STRATEGIES AND IDEAS (http://www.sqlservercentral.com/Forums/Forum363-1.aspx)
HOW TO MODEL CREDIT CARD TRANSACTION PROCESS? - Hi,
I am involved in the creation of a data mart to model credit card transactions. The grain of our Transaction_Fact... (http://www.sqlservercentral.com/Forums/FindPost407598.aspx)
|
|