killspid.blogspot.com
Killspid's blog...my own personal experience with SQL Server...
http://killspid.blogspot.com/
...my own personal experience with SQL Server...
http://killspid.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.3 seconds
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
7
SITE IP
172.217.9.225
LOAD TIME
0.277 sec
SCORE
6.2
Killspid's blog | killspid.blogspot.com Reviews
https://killspid.blogspot.com
...my own personal experience with SQL Server...
killspid.blogspot.com
Killspid's blog: May 2007
http://killspid.blogspot.com/2007_05_01_archive.html
My own personal experience with SQL Server. Thursday, May 24, 2007. CREATE PROC proc error. Date DATETIME = blabla - no good! DROP PROC proc error. Msg 0, Level 19, State 0, Procedure proc error, Line 4. SqlDumpExceptionHandler: Process 65 generated fatal exception c0000005 EXCEPTION ACCESS VIOLATION. SQL Server is terminating this process. Sunday, May 13, 2007. Solution, add plan guide. Exec sp create plan guide. Name = N'Plan for procedure p GrantInheritedAccess UPDATE'. Stmt = N'UPDATE poa1. AND poa2&...
Killspid's blog: Database snapshot files
http://killspid.blogspot.com/2007/11/database-snapshot-files.html
My own personal experience with SQL Server. Tuesday, November 27, 2007. Be aware of the fact that a database snapshot contains all the data of the referenced database at a certain moment. Not only the actual data, but also the metadata, the bookkeeping of Sql Server, is present in the snapshot. EXEC dbo.LongTermMemory Archive. The great SQL Server query archive. View my complete profile. Watermark template. Powered by Blogger.
Killspid's blog: Performance tuning guide for SQL Server
http://killspid.blogspot.com/2006/05/performance-tuning-guide-for-sql.html
My own personal experience with SQL Server. Friday, May 12, 2006. Performance tuning guide for SQL Server. I'm no Google-guru, so I actually had a lot of trouble finding the following documents. But because this is my long term memory, I couldn't do without them. So here it is, some indispensable old school performance tuning stuff: Microsoft SQL Server 2000 RDBMS Performance Tuning Guide for Data Warehousing. And the even more unfindable document version. Monitoring checkpoints in Profiler.
Killspid's blog: February 2008
http://killspid.blogspot.com/2008_02_01_archive.html
My own personal experience with SQL Server. Wednesday, February 20, 2008. Dive into msdb: BackupSet and RestoreHistory. Simple question today: can we find out how recent the backup is that has been used to restore our production copy? Backup set id =. Destination database name =. Subscribe to: Posts (Atom). Dive into msdb: BackupSet and RestoreHistory. EXEC dbo.LongTermMemory Archive. The great SQL Server query archive. View my complete profile. Watermark template. Powered by Blogger.
Killspid's blog: December 2007
http://killspid.blogspot.com/2007_12_01_archive.html
My own personal experience with SQL Server. Wednesday, December 05, 2007. Since our migration to Sql Server 2005 a couple of months ago, Integration Services has always been a constant point of attention to our database development team. That's mainly because of the necessary and upcoming migration of the existing DTS packages, but also because of the constant trouble we experience with the technology. Yep, we like it just as much as we hate it at times. Some random stuff from the past weeks.
TOTAL PAGES IN THIS WEBSITE
19
SQL Server Query Archive: oktober 2006
http://sqlqueryarchive.blogspot.com/2006_10_01_archive.html
SQL Server Query Archive. Maandag, oktober 09, 2006. Calculate waitstats - 2005. WITH TotalCTE (wait type, wait time ms, waiting tasks count) AS. SELECT wait type, wait time ms, waiting tasks count. FROM sys.dm os wait stats. WHERE wait type NOT IN ('SLEEP', 'RESOURCE QUEUE', 'OLEDB','WAITFOR', 'SQLTRACE BUFFER FLUSH', 'SLEEP TASK', 'LAZYWRITER SLEEP', 'MISCELLANEOUS'). SELECT SUM(wait time ms) FROM TotalCTE. FROM TotalCTE, TotalWait. ORDER BY Percentage DESC. Posted by WesleyB @ 12:54 pm.
SQL Server Query Archive: maart 2007
http://sqlqueryarchive.blogspot.com/2007_03_01_archive.html
SQL Server Query Archive. Maandag, maart 05, 2007. Get space used per file - 2000. CAST( ( FILEPROPERTY( name, 'SpaceUsed' ) * 8 ). 1024 AS numeric( 10, 2 ) ) as 'SpaceUsed',. CAST( ( size * 8 ) / 1024. AS numeric( 10, 2 ) ) as 'Reserved'. Posted by WesleyB @ 9:36 am. Foreign key index check - 2000. Drop all statistics - 2005. Get space used per file - 2000. The real SQL Server query archive. Space used - 2000. Calculate waitstats - 2005. Foreign key DROP/CREATE generator - 2005.
SQL Server Query Archive: april 2007
http://sqlqueryarchive.blogspot.com/2007_04_01_archive.html
SQL Server Query Archive. Dinsdag, april 03, 2007. Drop all statistics - 2005. DECLARE StatsCursor CURSOR FAST FORWARD. SELECT OBJECT NAME(object id) as 'ObjectName', [name] as 'StatsName' FROM sys.stats. WHERE (INDEXPROPERTY(object id, [name], 'IsAutoStatistics') = 1 OR INDEXPROPERTY(object id, [name], 'IsStatistics') = 1). AND OBJECTPROPERTY(object id, 'IsMSShipped') = 0. FETCH NEXT FROM StatsCursor. INTO @ObjectName, @StatsName. WHILE @ FETCH STATUS = 0. FETCH NEXT FROM StatsCursor. Space used - 2000.
SQL Server Query Archive: september 2006
http://sqlqueryarchive.blogspot.com/2006_09_01_archive.html
SQL Server Query Archive. Donderdag, september 07, 2006. Foreign key DROP/CREATE generator - 2005. IF OBJECT ID (N'dbo.GetFieldsConcat', N'FN') IS NOT NULL. DROP FUNCTION dbo.GetFieldsConcat;. CREATE FUNCTION dbo.GetFieldsConcat (@objectName sysname, @foreignKeyName sysname, @isParent bit). WITH EXECUTE AS CALLER. SET @theFields = '. SELECT @theFields = @theFields '[' CASE WHEN @isParent = 1 THEN pc.name ELSE cc.name END '],'. FROM sys.foreign keys fk. AND fk.name = @foreignKeyName. SELECT 'IF EXISTS (SE...
SQL Server Query Archive: juli 2007
http://sqlqueryarchive.blogspot.com/2007_07_01_archive.html
SQL Server Query Archive. Donderdag, juli 05, 2007. Foreign key index check - 2000. Select object name(constid) FKName,. Object name(fk.fkeyid) TableName,. Object name(fk.rkeyid) ReferenceTableName,. Join syscolumns sc on sc.id = fk.fkeyid and sc.colid = fk.fkey. Join syscolumns sc2 on sc2.id = fk.rkeyid and sc2.colid = fk.rkey. Where sik.id = fk.fkeyid. And sik.colid = sc.colid. And sik.keyno = 1 - first column in the index. Order by TableName, ReferenceTableName. Posted by killspid @ 1:55 pm.
SQL Server Query Archive: november 2006
http://sqlqueryarchive.blogspot.com/2006_11_01_archive.html
SQL Server Query Archive. Maandag, november 27, 2006. The real SQL Server query archive. Microsoft copied our initiative :-). Check it out here. Posted by WesleyB @ 9:42 am. Vrijdag, november 24, 2006. Space used - 2000. DBCC UPDATEUSAGE (0) WITH NO INFOMSGS;. Declare AllTables cursor fast forward for. Select name from sysobjects where type='u'. Index Size varchar(255),. Fetch from AllTables into @TableName. While @ FETCH STATUS=0. Exec sp spaceused @TableName. Fetch next from AllTables into @TableName.
TOTAL LINKS TO THIS WEBSITE
7
It's a blog...about nothing.
It's a blog.about nothing. The best thing, you've never read. Friday, November 18, 2011. I apologize for just leaving with nothing posted in months. Basking in the glow of another Cardinal World Series Championship, some new life decisions have been made. The amazing amount of hits this blog gets from the ever nutty ICP fans will always be remembered. How could it not be? So thank you very much, and I leave you with this.The Cardinals are World Champions.AGAIN! Friday, November 18, 2011. It FEELS like a ...
KILLSPENCER
PREMIUM ARTIFACTS HANDCRAFTED IN LOS ANGELES. Wednesday, July 22, 2009. Http:/ www.youtube.com/watch? This is probably the most exciting thing I've seen in a while. There is a future in the transportation industry after all. Monday, June 22, 2009. KILLSPENCER in STOCKHOLM, SWEDEN. Thursday, February 19, 2009. Ride to work wearing a messenger bag, which transforms into a briefcase when you arrive. Collection is made out of rare " Repurposed. Post Combat" Military truck tarps. Saturday, February 14, 2009.
KILLSPENCER® | Premium Artifacts Handcrafted in Los Angeles
Join our email list and enjoy 10% OFF. Be the first to know about our new products, events, and exclusive offers. Offer valid for new email subscribers only. By signing up, you agree to our Terms and Conditions. MADE IN LOS ANGELES. Special Ops Backpack 3.0 Collection. Special Ops Backpack 3.0 Collection. MADE IN LOS ANGELES. UTILITY SPECIAL OPS BACKPACK. FAQ and Care Instructions.
Talking about stuff, and junk
Talking about stuff, and junk. Random thought dumps from a .Net developer. Thursday, September 8, 2016. F5 Big-IP Load Balanced WCF Services - Update. The post below was some findings from a project related to the authentication between the front and back end services, and F5 configurations. It closely matches issues identified in my previous post. For the SSO server but that was using ntlm/kerberos (I have a feeling that we didn't set up the SPNs for kerberos correctly). Configure the endpoint. Note...
Killspid's blog
My own personal experience with SQL Server. Wednesday, April 15, 2009. Troubleshooting Performance Problems in SQL Server 2008". After the excellent white papers that were written for the previous versions. And with all the improvements that have been made in Sql Server 2008 in this area, I'm looking forward to read the new edition in the Troubleshooting Performance Problems series. You can find a link to download it here. Tuesday, March 31, 2009. SSRS configuring a rendering extension. His old blog tell...
How to Kill Spider Mite
How to Kill Spider Mite. Control of spider mite is an essential part of successful plant cultivation. It is especially important indoors or in hydroponic greenhouses where mites are favoured by the conditions and populations can explode. Magnified view of a spider mite. Spidermite Control is a preparation of natural organic vegetable oils and extracts that will quickly eradicate mite populations and mitigate the damage they cause. Buy Spidermite Control Online. Nite Nite Spider Mite. This video by the Ka...
Welcome killspidermites.net - BlueHost.com
Web Hosting - courtesy of www.bluehost.com.
Welcome killspidermites.org - BlueHost.com
Web Hosting - courtesy of www.bluehost.com.
KillSpiegel (Nickolas "Spiegel" Polishuk) - DeviantArt
Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Deviant for 4 Years. Last Visit: 3 days ago. This deviant's activity is hidden. Deviant since Jan 19, 2012. You can drag and drop to rearrange.
