You searched for the word(s):
Showing page 1 of 11 (104 total posts)
< 1 second(s)
Great post, Rob.
I just feel the need to emphasize the needed SET options when working with filtered indexes, as these settings a mandatory for all connections hitting that table.
So not only at create time of the index !
( bol/technet weren't clear on this : http://technet.microsoft.com/en-us/library/ms188783.aspx )
Been bit by it once ( on ...
this may be an interesting case for your request.
must be something in the url on this page. the copy/pasted url works ?-)
apparently the links are broken ... e.g. Updates on QDPMA Stats Stream - Updated points to http://www.qdpma.com/cbo/statstream.html which gives me "Server not found"
Nice fast lane solution, Allen.
I used this one to just list all queries for rdl files on a given location:
Since RDL is XML maybe just look for the query element
$RptFilePath = "X:\ItsMe\My Documents\SQL Server Management Studio\Custom Reports\"
$ResultFile = "$env:temp\ReportQueries.csv"
$RDLs = ...
Great piece of documentation and test cases.
Just a quick note:
Chances are Logman throws an error. This will not be captured in a Try/Catch because Logman puts that in its standard output.
Quick workaround can be:
"Logman start SQLPerf" | Out-File -FilePath $LogmanCmdFile -Force -Encoding default
$test = ( Start-Process -FilePath $LogmanCmdFile -Wait ...
Another great post, Allen.
Another example of powershell's versatility and the way it can serve use all.
I think they will classify this as a legacy documentation flaw.
If I recall well, it has been like that already in SQL 7.0
(for sure in sql2000)
it's nice to see a valid powershell solution to convert it into useful valid data.
This nice article also has nice refs about where to start ...
I'm sorry the url has a fixed ip address and no name, but anyways: http://126.96.36.199/index.php/2011/11/demise-of-the-graphical-user-interface-gui/#comment-46
Demise of the Graphical User Interface (GUI)
Posted on November 11, 2011 by Kyle Smith