Viewing 15 posts - 10,486 through 10,500 (of 49,552 total)
It'll be SQL Server using that, it's non-buffer memory. Reduce max server memory until you're happy with the available MB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 8:47 am
HanShi (1/6/2014)
p.avinash689 (1/6/2014)
I have a stored procedure like below.
USE [Mama]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[IP_BILLNO](@BILLNO NUMERIC(10) OUTPUT)
AS
DECLARE @Y NUMERIC(4,0),
@d VARCHAR(12),
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 6:18 am
Ed Wagner (1/6/2014)
GilaMonster (1/6/2014)
Ok, who has the crystal ball this week?http://www.sqlservercentral.com/Forums/Topic1527890-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic1528036-391-1.aspx
I think I'd have to vote for the 270-column table where the upload is not working properly. It made me...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 5:28 am
I don't know why you over-complicated matters so much, there were multiple nested queries for no reason, but this should work
ALTER PROCEDURE [dbo].[icanSP_Convert_GetEntityDependencies] @DocId INT,
@Count INT
AS
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 5:26 am
george sibbald (1/6/2014)
be aware your resource database will stay on the C drive and there is nothing you can do about that short of a reinstall.
and it must stay there...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 5:07 am
Ok, who has the crystal ball this week?
http://www.sqlservercentral.com/Forums/Topic1527890-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic1528036-391-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 5:07 am
Your procedure is fetching the greatest billNo from the table and just adding 1 to it. There's no logic anywhere in that procedure to set the bill number for a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 4:16 am
It tells SQL you don't care about the database that you're overwriting so not to give you the errors that you are losing data due to overwriting the DB.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 2:41 am
From Books Online
BEGIN TRANSACTION
Requires membership in the public role.
COMMIT
Requires membership in the public role.
So no additional permissions required.
To debug, you're going to have to dig into what exactly is happening...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 1:32 am
Why do you think partitioning will help?
Have you confirmed the problem is locking? If so, what kind of locks from what operation?
Have you pinpointed exactly where in the process the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 1:05 am
Still not enough information. Could be any number of things. Get the book I referenced, do some basic troubleshooting, identify what's happening.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 12:37 am
Open Books Online, browse (or search) to the page "Moving System Databases"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 6, 2014 at 12:01 am
Do some reading on SSIS, it's not hard but I'm not going to walk you through it step by step. Start with the SQL help files Books Online.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 5, 2014 at 1:41 pm
If it's going to be weekly I'd create an SSIS package and schedule that package with SQL Agent.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 5, 2014 at 12:22 pm
Import/export wizard will do that. In Management Studio right click the source databases -> tasks-> export data
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 5, 2014 at 12:02 pm
Viewing 15 posts - 10,486 through 10,500 (of 49,552 total)