Viewing 15 posts - 4,726 through 4,740 (of 49,552 total)
Kristen-173977 (9/19/2015)
I think the biggest problem (once SQL Injection is protected against) with dynamic SQL is if the queries are not parametrised.
Dynamic SQL can be parameterised, and protecting against SQL...
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
September 19, 2015 at 11:53 am
You're connecting to the default instance, not the new one. When you specify a port number, you connect to the SQL instance that's listening on that port. If it's not...
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
September 19, 2015 at 11:23 am
Backup times are mostly from IO. If your backups have slowed down and the sizes haven't increased, then it's likely that the IO throughput on the IO subsystem has decreased....
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
September 19, 2015 at 11:20 am
You're welcome
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
September 18, 2015 at 8:41 am
Could you post the definitions of the procedures with IDs 263724042 and 594153212 in database 5?
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
September 18, 2015 at 8:38 am
Phil Parkin (9/18/2015)
GilaMonster (9/18/2015)
SELECT ufnGetAccountingEndDate()Beat me to it.
What I would also suggest is that you always schema-qualify your DB objects:
select dbo.ufnGetAccountingEndDate();
Whoops.
Functions MUST be schema-qualified.
I suspect Kev did schema-qualify...
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
September 18, 2015 at 2:56 am
SELECT dbo.ufnGetAccountingEndDate()
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
September 18, 2015 at 2:40 am
Koen Verbeeck (9/17/2015)
Brandie Tarvin (9/17/2015)
24 hours of PASS begins in the next 20+ minutes!Are you registered?
Yes!
But probably will just see the recordings afterwards 🙂
Likewise. I need to spend tonight rehearsing...
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
September 17, 2015 at 7:34 am
1) Don't shrink data files without a good reason. It'll cause massive index fragmentation
2) Shrinking should be done only when something has resulted in a log/data file far larger than...
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
September 17, 2015 at 6:33 am
Cleared automatically meaning you're getting the cache flush messages in the error log? Or you're seeing the size of cached plans going to zero?
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
September 17, 2015 at 3:49 am
Providing the database doesn't contain persistent enterprise-only features (compression, partitioning, etc), then it is possible.
Please in future post new questions in a new thread.
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
September 17, 2015 at 2:40 am
Luis Cazares (9/16/2015)
create procedure UberProc (@QueryId varchar(50))
as
if @QueryId = 'First Horrible Idea'
begin
EXEC OneProcedure @PossibleParameter
end
if @queryid = 'Second really...
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
September 16, 2015 at 3:55 pm
Where are you seeing that SQL is only using 4 cores?
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
September 16, 2015 at 3:53 pm
Kristen-173977 (9/15/2015)
ScottPletcher (9/15/2015)
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
September 16, 2015 at 3:07 am
You'll have to change the name of Marketing before you can rename Marketing1. Even offline, it's still a database on the instance and database names have to be unique.
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
September 16, 2015 at 3:04 am
Viewing 15 posts - 4,726 through 4,740 (of 49,552 total)