Viewing 15 posts - 1 through 15 (of 21 total)
This is a bit late and I hope you already figured it out. In the case that you have not, here is how I do it.
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
March 16, 2022 at 12:05 am
Here is what I use to see data & log file growth
/*
-------------------------------------------------------------------------------------------------
NAME: DB_RecentFileGrowth.sql
MODIFIED BY: Sal Young
EMAIL: saleyoun@yahoo.com
DESCRIPTION: Displays...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
January 10, 2019 at 4:04 pm
I have following sample data set:
SaleID SaleMarkdown StartDate(yyyymmdd) EndDate(yyyymmdd) SaleInPreviousYear previousyearsaleID
1 20% ...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
October 24, 2018 at 6:46 am
This is a promising script but I'm having some issues.
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
September 11, 2018 at 6:53 am
I will assume you are using a programming language that is more efficient with patterns and string search to collect all these RSS feeds. Why not do your search...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
June 29, 2016 at 12:14 am
Here is my list of recommended steps
1. Develop a plan to learn the basics. The recommendations provided in this thread about your T-SQL skills are key and should be at...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
November 12, 2015 at 11:13 am
Help up help you by executing the code below on your server and replying to this conversation with the result. Replace the "YourDB" values with your database name.
SET NOCOUNT ON
USE...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
November 9, 2015 at 10:32 am
charipg,
You can take a look at the blog entry at the link below. Let me know if it helps!
How Do You Remove Logins From Your SQL Environment[/url]
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
April 4, 2011 at 8:16 am
[font="Verdana"]Adam,
I read your article and enjoyed every bit of it. Your writing style is superb and is consistent with the word “Introduction” from the title. I have read...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
March 17, 2011 at 11:09 am
Can someone tell me why I can't execute the Get-InvalidLogins. I set-location to the folder with all the SQLPSX code and execute as follow
PS [TPT60P]>.\Get-InvalidLogins
Unexpected token 'foreach' in expression...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
February 21, 2009 at 10:14 pm
cadebryant (9/22/2007)
Comments posted to this topic are about the item Display Row Count for all Tables
You could also use the system stored procedure sp_spaceused 'YourTableName' . I actually saved...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
September 24, 2007 at 2:19 pm
All you need is the "SQL Server Business Intelligence Development Studio" (included in the SQL 2005 installation DVD) or "Visual Studio 2005". Create a connection using the Server Explorer. Then,...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
February 12, 2007 at 10:07 am
Found the answer!
In MS SQL Server Management Studio, you have to give yourself exec rights to the dbo.sp_sdidebug extended stored procedure. This procedure is located in master > Programmability > Extended Stored...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
February 12, 2007 at 10:00 am
Wayne,
I'm going through the same thing right now and the only thing that comes up is the "Output" window with the result from executing the stored procedure.
I'm still researching & will...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
February 12, 2007 at 7:06 am
An observation/question to clarify. I believe that LIFO stands for "Last In First Out" & FIFO "First In First Out". If so, then the values you have for solutions 2...
[font="Verdana"]Sal Young[/font]
[font="Verdana"]MCITP Database Administrator[/font]
October 18, 2006 at 11:35 pm
Viewing 15 posts - 1 through 15 (of 21 total)