Viewing 15 posts - 18,586 through 18,600 (of 49,552 total)
What filegroup(s) are those files in?
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
May 9, 2012 at 11:57 am
Thomas Stringer (5/9/2012)
GilaMonster (5/9/2012)
When you open SSMS, Run As Administrator.Why would it be running under the security context of SSMS?
It's not. The attach itself runs under the 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
May 9, 2012 at 11:14 am
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
May 9, 2012 at 11:12 am
Putts (5/9/2012)
SELECT *FROM
dbo.getEmployees E
WHERE dbo.isIdealEmployee(E.EmployeeID) = 1
Function in where clause means that's likely to table scan every time, regardless of indexes.
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
May 9, 2012 at 11:10 am
Putts (5/9/2012)
If we didn't have any of the functions calling any of the other functions, would the performance still take a hit?
If they are multi-statement table valued functions, quite likely...
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
May 9, 2012 at 11:07 am
When you open SSMS, Run As Administrator.
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
May 9, 2012 at 10:34 am
Putts (5/9/2012)
In summation, what problems/deficiencies might I be introducing by changing these Views over to Table-based Functions as the Back End Source for my class constructors?
Performance.
I recall Grant telling 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
May 9, 2012 at 10:06 am
No real solution other than adding space. When restoring a database, there must always be enough space for the files.
p.s. Why did the log get to 14GB in the first...
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
May 9, 2012 at 10:01 am
http://ola.hallengren.com/Versions.html
http://sqlfool.com/2011/06/index-defrag-script-v4-1/
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
May 9, 2012 at 9:59 am
And before you use consider dynamic SQL, please read up on SQL Injection and make sure that you are fully familiar with what it is and how to defend against...
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
May 9, 2012 at 9:12 am
Jan Van der Eecken (5/9/2012)
GilaMonster (5/9/2012)
Rather don't use the information schema either, unless you need code that's compatible across database platforms...Why are you saying that, Gail?
Because they only show 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
May 9, 2012 at 8:08 am
If the table is partitioned, there will be multiple rows for that table in sys.partitions with different partition numbers. But unless you've explicitly partitioned the table, it won't be partitioned....
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
May 9, 2012 at 7:15 am
Rather don't use the information schema either, unless you need code that's compatible across database platforms.
Query sys.columns and sys.types for the type information for a query. Books Online has more...
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
May 9, 2012 at 5:28 am
The desktop is not C:\.
The desktop is a folder C:\Users\<logged in user>\Desktop. So that's where you need to write the backup, and you need to ensure that the SQL Server...
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
May 9, 2012 at 3:24 am
Windows has some restrictions about files in the root of a drive, especially C drive. Rather create a folder and write the backup into that. Make sure that the 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
May 9, 2012 at 2:26 am
Viewing 15 posts - 18,586 through 18,600 (of 49,552 total)