Viewing 15 posts - 9,856 through 9,870 (of 49,552 total)
BrainDonor (3/3/2014)
SQL Bits XII has finally been announced http://www.sqlbits.com/.
Wooot!
Next problem, what do I submit?
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
March 3, 2014 at 4:54 am
You need to drop all constraints, check constraints, foreign key, unique constraints, not disable them.
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
March 3, 2014 at 4:49 am
SQL_Surfer (3/2/2014)
After waiting for a while, I was able to detach the db, rename the log file and then attach it back without the log file.
Excellent way of destroying...
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
March 3, 2014 at 4:48 am
ALTER DATABASE ... MODIFY FILE
Take the DB offline (no need to restart SQL)
Copy the file to its new location
Bring the DB online
Practice on a non-production server 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
February 28, 2014 at 5:19 am
danielfountain (2/28/2014)
Surely if it was the where clause causing this issue then this would get round the issue.
No.
All you've done there is add an extra layer which the parser will...
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
February 28, 2014 at 5:02 am
Are there any answers for teams other than Team1 which have non-numeric values? If so, that's probably the cause. The case could be occuring on rows which would later be...
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
February 28, 2014 at 2:38 am
If you're using SQL 2012, use the 'catch-all' form (where Column=@Parameter or @Parameter IS NULL) and add the OPTION (RECOMPILE) to the query.
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
February 28, 2014 at 1:37 am
yuvipoy (2/27/2014)
Client needs the configuration with SQL Server 2012 on windows xp (if possible, else we would suggest other OS to client).
I would suggest a server operating system 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
February 28, 2014 at 12:42 am
Views and stored procs are stored within the system tables (they're just saved code), system tables are always on primary. While you can join from sys.indexes to sys.objects it will...
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
February 27, 2014 at 2:47 pm
Because - http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
February 27, 2014 at 1:55 pm
rodjkidd (2/27/2014)
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
February 27, 2014 at 1:08 pm
Ken.Cushing (2/27/2014)
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
February 27, 2014 at 9:35 am
DBO does not include trace permissions. You need to explicitly grant him the ALTER TRACE permission at the server level.
GRANT ALTER TRACE TO <login name>
The only fixed role which...
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
February 27, 2014 at 7:25 am
You need at least enough free space to hold the largest index (for a rebuild), otherwise the DB will grow
Other than that, OK/acceptable in terms of what?
If you have...
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
February 27, 2014 at 7:02 am
Koen Verbeeck (2/27/2014)
Maybe you can create an indexed view.
Maybe, maybe not. Might make other things worse, might not be possible. No way to tell.
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
February 27, 2014 at 6:41 am
Viewing 15 posts - 9,856 through 9,870 (of 49,552 total)