Viewing 15 posts - 2,701 through 2,715 (of 3,738 total)
Your data does not match so that even after constructing a query with valid joins you will not return any results.
The func_name column in the tbl_PI_Functions Table does not match...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 13, 2011 at 12:47 pm
I would suggest that you look into the JOIN Statement.
SELECT tbl_PI_Data.Date, tbl_PI_Data.Assoc_Name, tbl_PI_Associates.MgrName, tbl_PI_Data.Func_Name, tbl_PI_Data.Total_Proc, tbl_PI_Data.Prod_Hrs, tbl_PI_Data.Paid_Hrs, [Total_Proc]/[Prod_Hrs] AS PPH, tbl_PI_Functions.PPH_Goal, [Prod_Hrs]/[Paid_Hrs] AS PTP, tbl_PI_Functions.PTP_Goal
FROM tbl_PI_Functions INNER JOIN (tbl_PI_Associates INNER...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 12, 2011 at 2:41 pm
I do not use the wizard.
If you do it manually and you know what you are doing you can do it quickly,you know what you are doing and you can...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 12, 2011 at 1:43 pm
sqlquest2575 (7/11/2011)
Table Create Script and Insert Data Script--
CREATE TABLE [dbo].[tbl_PI_Associates](
[Assoc_Name] [nvarchar](50) NOT NULL,
[MgrName]...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 9:55 pm
Helical Johan (7/11/2011)
Hi,The machine memory is 4.00 GB, and maximun server memory is 3000 MB
It's getting kinda late but could you please elaborate on that?
Thanks!
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 9:49 pm
Digs (7/11/2011)
The base table has an...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 1:26 pm
I did not mean to create a stir but if you have 20+ Network Admins & multiple service account with Admin Privileges and you are told to lock SQL Server...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 11:49 am
kramaswamy (7/11/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 11:30 am
You can't use the UPDATE statement inside a function unless the UPDATE statement is directed to a table variable local to the function.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 11:07 am
GSquared (7/11/2011)
Welsh Corgi (7/10/2011)
Someone ask me if Kaplan's Self Test Software and Transender violate the NDA?Your input is greatly appreciated.
They probably have a contract with Microsoft. That kind of...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 10:56 am
GilaMonster (7/11/2011)
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Very impressive articles authored by you as usual. 😎
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 10:52 am
sqlquest2575 (7/11/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 11, 2011 at 10:18 am
Digs (7/10/2011)
Thanks, I think I cracked it !
I believe that there are additional actions that can be take to improve the performance than when I suggested.
You might want to find...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 10, 2011 at 9:00 pm
How large is your dataset?
Non Clustered Indexes?
Edit: I add my indexes after I load the Data.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 10, 2011 at 8:24 pm
GilaMonster (7/10/2011)
Welsh Corgi (7/10/2011)
george sibbald (6/22/2011)
why don't you want to use a DDL trigger?
I was wondering how you can prevent a member of the db_owner from from disabling or altering...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 10, 2011 at 8:07 pm
Viewing 15 posts - 2,701 through 2,715 (of 3,738 total)