sql server 2005 install hangs at “Removing Backup Files”

sql server 2005 install hangs at "Removing Backup Files"

I’m installing sqlserver 2005, and it seemed to hang towards the end of the installation. The installer hung while it was installing ‘Workstation Components, Books Online’, with the progress message being ‘Removing Backup Files’. As it happened I kicked this off at the end of the day, and it was still hanging the next morning …

sql and powershell sketchnotes – jan – mar 2015

sql and powershell sketchnotes - jan - mar 2015

Statement Execution and the Plan Cache I think that there was a point about stored procedures and caching that I didn’t quite get or capture. I need to do some investigation on this. Here’s the archived meeting details – I think the recording of the session will show up here in due course. http://dbafundamentals.sqlpass.org/MeetingDetails.aspx?EventID=2101 Kimberly’s …

70-461 – notes for ch. 2 – dates

70-461 - notes for ch. 2 - dates

Different date precisions Trying out different styles of date in sql server. The following… select getdate() select CURRENT_TIMESTAMP select SYSDATETIME() select SYSDATETIMEOFFSET() select CAST(SYSDATETIME() AS DATE) select GETUTCDATE() …gives 2015-01-08 12:54:04.310 2015-01-08 12:54:04.310 2015-01-08 12:54:04.31 2015-01-08 12:54:04.3131631 +00:00 2015-01-08 2015-01-08 13:01:21.077 Datepart Datepart works as follows: select DATEPART(year, getdate()) select DATEPART(MONTH, getdate()) select DATEPART(DAY, getdate()) …

70-461 – notes for ch. 2 – datatypes

70-461 - notes for ch. 2 - datatypes

Varchar vs. char To demo, creating two tables one with varchar and one with char drop table aa.tax_dodgers create table aa.tax_dodgers (name char(2000)) — create a few rows insert into aa.tax_dodgers values (‘Google’), (‘Amazon’), (‘Facebook’),(‘Google’), (‘Amazon’), (‘Facebook’), (‘Google’), (‘Amazon’), (‘Facebook’),(‘Google’), (‘Amazon’), (‘Facebook’),(‘Google’), (‘Amazon’), (‘Facebook’), (‘Google’), (‘Amazon’), (‘Facebook’),(‘Google’), (‘Amazon’), (‘Facebook’) drop table aa.vtax_dodgers create table aa.vtax_dodgers …

70-461 – notes from ch. 2 – table and alias naming

70-461 - notes from ch. 2 - table and alias naming

Some notes from reading Chapter 2 of Querying Microsoft SQL Server 2012 (MCSA) by By Dejan Sarka, Itzik Ben-Gan, Ron Talmage Tables and aliases If you alias a table, then you can’t use the full table name. i.e. If you use the table name having defined the alias like so: SELECT Employees.empid, firstname, lastname FROM …

70-461 – sketchnote from chapter 1

70-461 - sketchnote from chapter 1

I’m reading Querying Microsoft SQL Server 2012 by By Dejan Sarka, Itzik Ben-Gan, Ron Talmage and I thought it would be good to post something for each chapter. My first offering is a sketchnote of the order in which a query is performed. The example from the book is SELECT country, YEAR(hiredate) AS yearhired, COUNT() …

70-461 – spatial aggregates – geometry

70-461 - spatial aggregates - geometry

The Exam 70-461: Querying Microsoft SQL Server 2012 syllabus has the following under the ‘Work with Data’ section: Implement aggregate queries New analytic functions; grouping sets; spatial aggregates; apply ranking functions The highlighted bit it what I’m looking at here Insert and select with geometry So, first create a table with a column with the …

70-461 notes #2 – demo-ing the date datatypes

70-461 notes #2 - demo-ing the date datatypes

I’ve had a play with the date and time data types: create table demo_dates (demo_datetime datetime, demo_datetime2 datetime2, demo_date date, demo_time time, demo_datetimeoffset datetimeoffset) insert into demo_dates select GETDATE(), GETDATE(), GETDATE(), GETDATE(), GETDATE() <code> select * from demo_dates&lt;/code&gt; </code> Gives: 2014-12-15 16:50:02.247 2014-12-15 16:50:02.2470000 2014-12-15 16:50:02.2570000 2014-12-15 16:50:02.2570000 +00:00 I presume that the datetime2 field …

php comments not working in wordpress

php comments not working in wordpress

This was a bit of a ‘Duh!’ moment. I use the following to ‘comment out’ chunks of WordPress pages that I’m still working on <?php /* Some old rubbish that I have’nt finished working on yet */?> This seemed to have ‘stopped working’. The reason was my ‘Exec-PHP’ plugin was de-activated. I don’t remember de-activating …