Viewing 15 posts - 13,681 through 13,695 (of 49,552 total)
Have a look at the sys.dm_db_task_space_usage and sys.dm_db_session_space_usage DMVs.
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 28, 2013 at 8:59 am
It's probably just a quick example, or an obfuscated table. See the column names that I use in my writing for useless.
Usually like
SELECT SomeInt, SomeString, SomeDate from SomeTable
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 28, 2013 at 8:52 am
Just a quick comment on the process, not the query...
Unless you've taken the full backup WITH CHECKSUM, the verifyonly verifies very little of the backup and can easily verify 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
March 28, 2013 at 8:51 am
Welcome to Books Online. I personally love the sections that are completely, blatantly wrong.
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 28, 2013 at 8:12 am
Log backup size in full and bulk logged recovery model will be roughly the same size.
Full recovery the entire size of the data inserted goes into the log records 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
March 28, 2013 at 8:09 am
Manual task.
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 28, 2013 at 4:42 am
Log backups don't change the size of the file, they just mark the space inside as reusable.
Please read through this - Managing Transaction Logs[/url]
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 28, 2013 at 3:21 am
On the log file, too tired to explain, but these should cover most.
Managing Transaction Logs[/url]
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 27, 2013 at 4:41 pm
Free up space on the drive and the database will carry on working with no additional work on your side. Worst case, if you can't, add a second log file...
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 27, 2013 at 4:33 pm
KoldCoffee (3/27/2013)
As I said, I don't know who the other users are so I can't alter permissions on user.
You don't need to alter permissions on a user (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
March 27, 2013 at 4:28 pm
Elizabeth.Block (3/27/2013)
I had heard eons ago that SQL Server would shut itself down if it ran out of disk space. Is this an urban myth?
It shouldn't do. There's probably...
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 27, 2013 at 4:23 pm
SQL shouldn't shut down due to lack of space, unless something bad went wrong in the system DBs. It would normally just roll back the offending transactions, at most make...
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 27, 2013 at 4:07 pm
The MSDN page you quoted above has the information you're asking for.
To see other users, requires ALTER ANY USER, or a permission on the user.
So, to view all the users,...
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 27, 2013 at 4:02 pm
Take the DB offline, bring it online. Of course that also kicks all users out, clears the plan cache and the data cache, so may not be desirable.
Why not save...
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 27, 2013 at 3:03 pm
Does this do what you want?
DECLARE @StartDate DATETIME = '2011-01-01',
@EndDate DATETIME = '2012-03-31';
WITH Base AS (
SELECT * FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) b (number)
),
Calendar AS (
SELECT DATEADD(dd,ROW_NUMBER() OVER (ORDER BY (SELECT...
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 27, 2013 at 2:54 pm
Viewing 15 posts - 13,681 through 13,695 (of 49,552 total)