
moresqlplease.blogspot.com
The Adventures of a SQL Server DBATips on T-SQL, SQL Server DBA stuff, and more!
http://moresqlplease.blogspot.com/
Tips on T-SQL, SQL Server DBA stuff, and more!
http://moresqlplease.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.6 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
1
SITE IP
172.217.3.97
LOAD TIME
0.578 sec
SCORE
6.2
The Adventures of a SQL Server DBA | moresqlplease.blogspot.com Reviews
https://moresqlplease.blogspot.com
Tips on T-SQL, SQL Server DBA stuff, and more!
The Adventures of a SQL Server DBA: October 2013
http://moresqlplease.blogspot.com/2013_10_01_archive.html
The Adventures of a SQL Server DBA. Tips on T-SQL, SQL Server DBA stuff, and more! Friday, October 4, 2013. Reboot Windows 2000, XP, and Vista from a Command Prompt. SHUTDOWN -r -t 01. Then press Enter. In a dozen years of working in technology, I never had occasion to do this. The great thing about technology is that I am always learning new things =). Labels: Windows Server Administration. Location: Columbus, GA 31904, USA. Subscribe to: Posts (Atom). Reboot Windows 2000, XP, and Vista from a Command .
The Adventures of a SQL Server DBA: August 2013
http://moresqlplease.blogspot.com/2013_08_01_archive.html
The Adventures of a SQL Server DBA. Tips on T-SQL, SQL Server DBA stuff, and more! Monday, August 26, 2013. Querying the Default Trace File. There are several ways to run this query. Here is one that I am currently using in production to track any configuration changes:. DECLARE @TRC PATH VARCHAR(500). SELECT @TRC PATH = CONVERT(VARCHAR(500), value). FROM fn trace getinfo(DEFAULT). WHERE property = 2. SELECT TEXTData, HostName, ApplicationName, DatabaseName, LoginName, SPID, StartTime. AND SPID @ spid.
The Adventures of a SQL Server DBA: The DATALENGTH() Function
http://moresqlplease.blogspot.com/2012/11/the-datalength-function.html
The Adventures of a SQL Server DBA. Tips on T-SQL, SQL Server DBA stuff, and more! Wednesday, November 14, 2012. Of course, you know what happened:. Msg 8116, Level 16, State 1, Line 3. Argument data type text is invalid for argument 1 of len function. So, the LEN() function cannot be used on text type fields. Was there a LEN() equivalent for the text type? A little googling revealed that there was:. This function was exactly what I needed to get the length for a text type field. View my complete profile.
The Adventures of a SQL Server DBA: Reboot Windows 2000, XP, and Vista from a Command Prompt
http://moresqlplease.blogspot.com/2013/10/reboot-windows-2000-xp-and-vista-from.html
The Adventures of a SQL Server DBA. Tips on T-SQL, SQL Server DBA stuff, and more! Friday, October 4, 2013. Reboot Windows 2000, XP, and Vista from a Command Prompt. SHUTDOWN -r -t 01. Then press Enter. In a dozen years of working in technology, I never had occasion to do this. The great thing about technology is that I am always learning new things =). Labels: Windows Server Administration. Location: Columbus, GA 31904, USA. Subscribe to: Post Comments (Atom). View my complete profile.
The Adventures of a SQL Server DBA: July 2012
http://moresqlplease.blogspot.com/2012_07_01_archive.html
The Adventures of a SQL Server DBA. Tips on T-SQL, SQL Server DBA stuff, and more! Monday, July 30, 2012. Rebuilding Indexes with T-SQL. USE [DB NAME GOES HERE]. CREATE TABLE #TEMP(ID INT IDENTITY(1,1), [TABLE NAME] VARCHAR(200). SELECT '[' S.NAME '].[' T.NAME ']' AS [TABLE NAME], I.NAME AS [IX NAME]. FROM SYS.INDEXES I. INNER JOIN sys.tables T. ON Iobject id = T.object id. INNER JOIN sys.schemas S. ON Tschema id = S.schema id. WHERE I.INDEX ID 0. ORDER BY T.NAME, I.NAME. SET @SQL = ' BEGIN TRY. Great Qu...
TOTAL PAGES IN THIS WEBSITE
19
Our Local Bloggers
http://columbusga.sqlpass.org/Bloggers.aspx
SQL Server Users Group. We have several local bloggers who write things about SQL and other techie things. Check them out. Tim Radney http:/ www.timradney.com. Jonathan Boulineau http:/ www.newsqlblog.com. Jason Griffith http:/ www.moresqlplease.blogspot.com . Brian Bolton http:/ www.fountaincitycode.com/.
TOTAL LINKS TO THIS WEBSITE
1
Desserts Divine
More Sprinkles for Me...
You have found a blog dusted with powdered sugar and topped with sprinkles. This blog gives tips, tricks, and step by step recipes for different sweets and treats! Go find your apron, you'll need it for these AWESOME desserts! Wednesday, April 30, 2014. April showers bring. Rainbow Cupcakes! April is almost over, but you know what they say, April showers bring.Rainbows! Next, I baked some vanilla cupcakes, but a fun idea would be to dye the batter and make it "rainbow-y" too! I saved a few spoonful's of ...
Moresprudentie - Welkom
Deze site biedt studenten en docenten een grote hoeveelheid vragen en opdrachten die een directe relatie hebben met de hoofdstukken in het boek Moresprudentie, ethiek en beroepscode in het sociaal werk. De toetsen en opgaven helpen de ingewikkelde materie van de beroepsethiek te verwerken. Het materiaal is per hoofdstuk gerangschikt en ingedeeld in de volgende categorieën:. 1 Toets je kennis (toets de in het boek behandelde theorie). 2 Casus (diverse casussen met vragen). Meer over het boek. Vraag een gr...
moresq.com - Registered at Namecheap.com
This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! The Sponsored Listings displayed above are served automatically by a third party. Neither Parkingcrew nor the domain owner maintain any relationship with the advertisers.
The Adventures of a SQL Server DBA
The Adventures of a SQL Server DBA. Tips on T-SQL, SQL Server DBA stuff, and more! Friday, March 2, 2018. List all Stored Procedures on a SQL Server that get Executed. Create date: 09 Feb 2015. Description: Returns a listing of all SPs on the server that get used. Modify date: 02 Mar 2018. SELECT st.dbid [DB ID]. DB NAME(st.dbid) [Database]. OBJECT SCHEMA NAME(st.objectid,dbid) [Schema]. OBJECT NAME(st.objectid,dbid) [StoredProcedure]. FROM sys.dm exec cached plans cp. AND cp.objtype = 'proc'. Being a DB...
moresqua's blog - Ma vie a moi - Skyrock.com
Ma vie a moi. Comme le nom du blog le dit c'est ma vie a moi que je vais raconté en quelques images et tenir souvent a jour.(me blamer pas first blog pour moi ). 05/07/2008 at 1:13 PM. 07/07/2008 at 3:34 AM. Subscribe to my blog! Mon frère(et oui je parle beaucoup de lui), est talentueux:. Pour le théatre(cf en dessous). Mais aussi la musique(rockeur dans l'ame). Please enter the sequence of characters in the field below. Posted on Sunday, 06 July 2008 at 3:38 PM. Mon frère dans cirano de bergerac. L'ann...
MORESquared
Sistema de archivo universal. Sistema de archivo universal. Suscríbete para recibir nuestras novedades. Muebles Km 0: Del origen hasta su entrega. FIT llega para revolucionar la oficina moderna. Ecoefficiency: otra manera de ahorrar energía. Cómo conocer y sacarle el mayor partido a tu espacio de trabajo. Nuevas tendencias de año nuevo para tu oficina. Calle Milán, 14. Polígono Industrial del Clot. 08291 Ripollet, Barcelona. Teléfono: 935 94 61 22. Fax: 935 94 73 07.
moresquarefeet.com
This domain is available for sale. To purchase, call Afternic at 1 781-314-9607 or 844-886-1722. Click here to inquire.
moresquarefeetlessmoney.com
More Squash Please
A Vegan Food and Lifestyle Blog. Raleigh Vegan Dining Guide. Chirba Chirba Dumpling Truck. The Chirba Chirba Dumpling Truck. Just pulled up outside my office, and I couldn’t resist the charm of its mascot. Painted on the side of the yellow truck, the smiling, plump, cartoon dumpling seemed to say “please eat me… I am so scrumptious and cheerful.”. Chela Tu, co-owner of Chirba Chirba Dumpling Truck. 8221; in Mandarin Chinese, sort of like the expression “Mangia, mangia! That I heavily modified to make the...