Viewing 15 posts - 1,366 through 1,380 (of 7,502 total)
and of course, your function causes any indexes defined on that column not to be used as efficient as possible, if used at all.
No doubt, change the code or buy...
May 21, 2012 at 2:36 pm
TheSQLGuy (5/21/2012)
Note that Instant File Initialization does not work when you are using TDE. See msdn.microsoft.com/en-us/library/bb934049.aspx for more info.
Good remark.
That restriction, of course, also goes when restoring a...
May 21, 2012 at 2:29 pm
Indeed.
Instant File Initialization will kick in on database create as well as a direct db restore.
As Robert stated, there may even be a cutt off of your restore time...
May 21, 2012 at 10:38 am
Robert Davis (5/20/2012)
May 21, 2012 at 12:08 am
keep it easy.
Just ad a column to manage the user status.
enabled/disabled/suspended/blocked
This way your "check non-active 3days" application only has to put the column to the value that goes for blocked...
May 11, 2012 at 12:11 am
Have a look at:
- http://msdn.microsoft.com/en-us/library/hh245202.aspx
- http://sqlblog.com/blogs/allen_white/archive/2008/12/07/loading-smo-assemblies-into-powershell.aspx
- http://www.mssqltips.com/sqlservertip/1745/using-powershell-with-sql-server-management-objects-smo/
## load SMO assemblies
## use $null to prevent display of assembly load information
$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended")
$null = [reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo")
May 9, 2012 at 6:55 am
did you try to execute your package from Powershell_ISE , PowerGUI or PowerSE (which are all free tools)
Which version of powershell / SQLserver are you using ?
Apparently you didn't load...
May 9, 2012 at 5:46 am
Details on the error(s) do matter !
Did you have a look at :
- http://www.codeproject.com/Articles/110908/SQL-DB-Restore-using-PowerShell
or
- http://www.sswug.org/articles/viewarticle.aspx?id=44909
or
May 9, 2012 at 5:17 am
That is a way to test if your backups work.
Keep in mind, you cannot restore a higher version backup to a lower version instance !
Also keep in mind, if you...
May 4, 2012 at 7:41 am
Did anybody notice SSC passed 1,500,000 members ?
Great job and thank you for the learning opportunities this wonderful resource provides. :kiss:
May 4, 2012 at 1:51 am
the reason why I always start coding the where clause when typing an update query.
May 3, 2012 at 12:58 am
That's indeed what it is supposed to be.
May 3, 2012 at 12:44 am
- Keep in mind , your domain administrator account doesn't automatically have SQLServer administrator privileges !
- did you try changing the default database for DomainName\Administrator ?
May 3, 2012 at 12:38 am
for those interested, you can still download the free ebook The Art of XSD By Jacob Sebastian at the Redgate books section:
May 3, 2012 at 12:27 am
1) please post some ddl of all involved objects and their indexes
2) please post an execution plan
3) I guess your MessageTimeStamp column has been declare char(23) and it...
May 3, 2012 at 12:15 am
Viewing 15 posts - 1,366 through 1,380 (of 7,502 total)