Viewing 15 posts - 11,176 through 11,190 (of 49,552 total)
rivermorrison22 (10/28/2013)
So when you re-index, you move the data around. That would make the non-clustered indexes invalid right?
Nope. Nonclustered indexes don't contain the row's physical location when...
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
October 28, 2013 at 9:30 am
What account is SQL running under? Domain, local system, other?
Does the path exist? If that was intended as a UNC path, it's missing a \ at the beginning. If it's...
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
October 28, 2013 at 9:27 am
Your permissions are irrelevant.
Does the SQL Server service account (the account that SQL runs under) have permission to write to that folder?
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
October 28, 2013 at 9:10 am
Is there a schema called sproc and does it have a procedure named Infmtx_003_MonthlyAR?
According to what you said a month ago, it does not. I will re-quote
vba317 (9/25/2013)
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
October 28, 2013 at 8:52 am
Apparently the current top database guy at the company I'm joining is ecstatic about my joining them. From what I heard from one of the other devs, he has 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
October 28, 2013 at 8:34 am
They'll both do pretty much the same thing, the DROP/CREATE is more typing and more prone to typing errors.
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
October 28, 2013 at 7:29 am
exec dbo.sproc.Infmtx_003_MonthlyAR.
And there is your problem, by specifying 3-part naming, you've said the database name is dbo, the schema is sproc and the procedure name is Infmtx_003_MonthlyAR. Since you're...
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
October 28, 2013 at 7:28 am
Bhuvnesh (10/28/2013)
I also read it many places but does microsoft(msdn) say the same ?
Books Online states that the clustered index enforces physical storage order. Books Online is wrong, on this...
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
October 28, 2013 at 7:24 am
J Livingston SQL (10/27/2013)
are these credit/payment card numbers that you are attempting to obfuscate by any chance??...just interested??
I seriously hope not. If they are, they should be getting encrypted, 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
October 27, 2013 at 5:14 pm
Without table names, data types, column names, not really. Look up substring. Couple of those should together do what you want. Or you could use LEFT and RIGHT instead...
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
October 27, 2013 at 1:14 pm
Either change the source file before you import it or run an update afterwards.
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
October 27, 2013 at 10:03 am
Revenant (10/25/2013)
If the candidate has less than 12 years on SQL Server and rates himself - much less frequently herself - 8 or higher, the interview effectively ends right there.
I'd...
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
October 26, 2013 at 2:10 pm
Luis Cazares (10/25/2013)
Or am I wrong?
The only thing you need is that the table is empty and the insert specifies a tablock. Note that TempDB's logging is optimised over user...
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
October 25, 2013 at 11:02 am
madhu-686862 (10/25/2013)
That means, clearly some OS process is taking lot of memory. But how to find what it is?
GilaMonster (10/22/2013)
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
October 25, 2013 at 10:55 am
Luis Cazares (10/25/2013)
SELECT...INTO... statements aren't bad for performance. Actually, with good coding habits they can be a lot better. This is just on how the processes are logged.
Insert into and...
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
October 25, 2013 at 10:35 am
Viewing 15 posts - 11,176 through 11,190 (of 49,552 total)