SELECT
t.NAME AS TableName,
i.name as indexName,
p.[Rows],
sum(a.total_pages) as TotalPages,
sum(a.used_pages) as UsedPages,
sum(a.data_pages) as DataPages,
(sum(a.total_pages) * 8) / 1024 as TotalSpaceMB,
(sum(a.used_pages) * 8) / 1024 as UsedSpaceMB,
(sum(a.data_pages) * 8) / 1024 as DataSpaceMB
FROM
sys.tables t
INNER JOIN
sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN
sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN
sys.allocation_units a ON p.partition_id = a.container_id
WHERE
t.NAME NOT LIKE 'dt%' AND
i.OBJECT_ID > 255 AND
i.index_id <= 1
GROUP BY
t.NAME, i.object_id, i.index_id, i.name, p.[Rows]
ORDER BY
object_name(i.object_id)
Category Archives: Microsoft
SQL ServerQuery to list number of records in each table in a database
7 de Outubro de 2015 – 13:20
SQL SERVER – FIX : Error 15023: User already exists in current database.
9 de Abril de 2015 – 11:17
Error 15023: User already exists in current database.
1) This is the best Solution.
First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan.
USE YourDB GO EXEC sp_change_users_login 'Report' GO
Run following T-SQL Query in Query Analyzer to associate login with the username. ‘Auto_Fix’ attribute will create the user in SQL Server instance if it does not exist. In following example ‘ColdFusion’ is UserName, ‘cf’ is Password. Auto-Fix links a user entry in the sysusers table in the current database to a login of the same name in sysxlogins.
USE YourDB GO EXEC sp_change_users_login 'Auto_Fix', 'ColdFusion', NULL, 'cf' GO
Run following T-SQL Query in Query Analyzer to associate login with the username. ‘Update_One’ links the specified user in the current database to login. login must already exist. user and login must be specified. password must be NULL or not specified
USE YourDB GO EXEC sp_change_users_login 'update_one', 'ColdFusion', 'ColdFusion' GO
more details in http://blog.sqlauthority.com/2007/02/15/sql-server-fix-error-15023-user-already-exists-in-current-database/
Select all sites in IIS manager
13 de Março de 2015 – 17:57
You should be able to do:
cd %systemroot%\system32\inetsrv\
and then delete them
appcmd list site /xml | appcmd delete site /in
Datetime format / Globalization
3 de Março de 2015 – 16:32
<pre class="default prettyprint prettyprinted"><code><span class="tag"><configuration> </span><span class="tag"><system.web> </span><span class="tag"><globalization</span><span class="atn">culture</span><span class="pun">=</span><span class="atv">"en-GB"</span><span class="tag">/> </span><span class="tag"></system.web> </span><span class="tag"></configuration></span></code></pre>
ASP.Net Character Length Regular Expression Validators
10 de Julho de 2014 – 10:53
ASP.Net RegularExpression Validators
Maximum character length Validation (Maximum 6 characters allowed)
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:RegularExpressionValidator runat="server" ID="RegularExpressionValidator1"
Display = "Dynamic"
ControlToValidate = "TextBox1"
ValidationExpression = "^[\s\S]{0,6}$"
ErrorMessage="Maximum 6 characters allowed.">
</asp:RegularExpressionValidator>
Minimum character length Validation (Minimum 6 characters required)
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>
<asp:RegularExpressionValidator runat="server" ID="RegularExpressionValidator2"
Display = "Dynamic"
ControlToValidate = "TextBox2"
ValidationExpression = "^[\s\S]{6,}$"
ErrorMessage="Minimum 6 characters required.">
</asp:RegularExpressionValidator>
Minimum and Maximum character length Validation (Minimum 2 and Maximum 6 characters required)
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>
<asp:RegularExpressionValidator runat="server" ID="RegularExpressionValidator3"
Display = "Dynamic"
ControlToValidate = "TextBox3"
ValidationExpression = "^[\s\S]{2,6}$"
ErrorMessage="Minimum 2 and Maximum 6 characters required.">
</asp:RegularExpressionValidator>
Alphanumeric with special Characters
Minimum length 7 and Maximum length 10. Characters allowed – a – z A – Z 0-9 ’@ & # .
<asp:RegularExpressionValidator ID="RegExp1" runat="server"
ErrorMessage="Password length must be between 7 to 10 characters"
ControlToValidate=" txtPassword "
ValidationExpression="^[a-zA-Z0-9'@&#.\s]{7,10}$" />
Alphanumeric Only
Minimum length 7 and Maximum length 10. Characters allowed – a – z A – Z 0-9
<asp:RegularExpressionValidator ID="RegExp1" runat="server"
ErrorMessage="Password length must be between 7 to 10 characters"
ControlToValidate=" txtPassword "
ValidationExpression="^[a-zA-Z0-9\s]{7,10}$" />
Alphabets Only
Minimum length 7 and Maximum length 10. Characters allowed – a – z A – Z
<asp:RegularExpressionValidator ID="RegExp1" runat="server"
ErrorMessage="Password length must be between 7 to 10 characters"
ControlToValidate="txtPassword"
ValidationExpression="^[a-zA-Z]{7,10}$" />
Numeric Only
Minimum length 7 and Maximum length 10. Characters allowed – 0 – 9
<asp:RegularExpressionValidator ID="RegExp1" runat="server"
ErrorMessage="Password length must be between 7 to 10 characters"
ControlToValidate="txtPassword"
ValidationExpression="^[0-9]{7,10}$" />
source:
http://www.aspsnippets.com/Articles/ASP.Net-Regular-Expression-Validator-to-validate-Minimum-and-Maximum-Text-Length.aspx
VBA environment variables (ENVIRON)
4 de Julho de 2014 – 14:36
To see a list of variables, create a sub:
Sub ListEnvironmentVariables()
'each environment variable in turn
Dim EnvironmentVariable As String
'the number of each environment variable
Dim EnvironmentVariableIndex As Integer
'get first environment variables
EnvironmentVariableIndex = 1
EnvironmentVariable = Environ(EnvironmentVariableIndex)
'loop over all environment variables till there are no more
Do Until EnvironmentVariable = ""
'get next e.v. and print out its value
Debug.Print EnvironmentVariableIndex, EnvironmentVariable
'go on to next one
EnvironmentVariableIndex = EnvironmentVariableIndex + 1
EnvironmentVariable = Environ(EnvironmentVariableIndex)
Loop
End Sub
click menu “View” > “Immediate Window” and run it
Doesn’t work on macintosh
Private Sub Workbook_Open()
'Generates a GUID:
Sheet1.Cells(8, 3).Value = Mid$(CreateObject("Scriptlet.TypeLib").GUID, 2, 36)
'environment variables:
Sheet1.Cells(11, 3).Value = Environ$("computername")
Sheet1.Cells(12, 3).Value = Environ$("username")
Sheet1.Cells(13, 3).Value = Environ$("USERPROFILE")
MsgBox "Hello " & Environ$("username")
End Sub
on Macintosh Excel you can try a AppleScript, something like:
Function GetUserNameMac() As String
Dim sMyScript As String
sMyScript = "set userName to short user name of (system info)" & vbNewLine & "return userName"
GetUserNameMac = MacScript(sMyScript)
End Function
IIS6 and Office 2007 MIME types
26 de Maio de 2014 – 10:26
Error message:
HTTP Error 404 – File or directory not found.
Internet Information Services (IIS)
Since Office 2007 was released after Windows Server 2003 and IIS6, IIS6 knows nothing about the new MIME types. So you need to manually add them:
Open Computer Management. (Right-click My Computer… Manage…)
Right-click Internet Information Services (IIS) Management… Properties…
Click MIME Types…
Click New… and add the following:
Extension MIME Type
.xlsx application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
.xltx application/vnd.openxmlformats-officedocument.spreadsheetml.template
.potx application/vnd.openxmlformats-officedocument.presentationml.template
.ppsx application/vnd.openxmlformats-officedocument.presentationml.slideshow
.pptx application/vnd.openxmlformats-officedocument.presentationml.presentation
.sldx application/vnd.openxmlformats-officedocument.presentationml.slide
.docx application/vnd.openxmlformats-officedocument.wordprocessingml.document
.dotx application/vnd.openxmlformats-officedocument.wordprocessingml.template
.xlam application/vnd.ms-excel.addin.macroEnabled.12
.xlsb application/vnd.ms-excel.sheet.binary.macroEnabled.12
Exchange 2010 Database size
7 de Fevereiro de 2014 – 17:28
- Review the Purge items from the Recoverable Items folder. For details, see Clean Up the Recoverable Items Folder.
- Yes ESEutil /D is the command
- Safe? Yes relatively, however, that said
- before you ever run any type of utility against an Exchange database you should back it up just in case something goes sideways.
- you will need 110% of the EDB size to perform the defrag and
- during the time its being defragged ALL users for that database will be unable to connect.
- Time, well this depends upon many factors, i.e. CPU, Disk Speed, Memory, other processes etc. Basically I would plan to spend at least a full day on it. But whatever you do you need to be patient because it does take time to complete.
- Personally I think you would be better off to create a NEW database and use the New-MoveRequest so check out these two articles http://technet.microsoft.com/en-us/library/bb124495.aspx and http://technet.microsoft.com/en-us/library/bb124797.aspx since these will allow you to keep the system up and running while the data is being moved, however it does require more disk space until the process is done and then you can drop the old DB to gain all the space back.
Export to CSV all your Exchange 2007/2010 Email Addresses
5 de Fevereiro de 2014 – 11:41
If you want to export all your users email addresses to a CSV so you can see who has which alias you can do this with this Power Shell Command
Get-Mailbox -ResultSize Unlimited
|Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses
|Where-Object {$_.PrefixString -ceq “smtp”}
| ForEach-Object {$_.SmtpAddress}}}
| Export-CSV c:\smtp.csv -NoTypeInformation
I have wrapped it here so just paste it in to Power Shell to run and this will show the Primary Email address and then all the alias addresses.
http://cscmblog.blogspot.pt/2012/02/export-to-csv-all-your-exchange.html
Concatenate data fields as binding expression
31 de Janeiro de 2014 – 16:29
Concatenate data fields as binding expression:
<asp:label id="Label1" runat="server"
text='<%# String.Format("{0}, {1}", Eval("ContactLastName"), Eval("ContactFirstName")) %>'>
</asp:label>
how to implemented mailto in Hyperlink asp control inside the gridview:
<asp:HyperLink id="hl1" runat="server"
NavigateUrl='<%# Eval("Email" , "mailto:{0}") %>'
Text='<%# Eval("Email") %>'>
</asp:HyperLink>
Home