Browsing Tag
Default category for Blog Content
I’m back in Austin from SQL Saturday 408 in Houston, TX and back at work. The event was a great success and I liked everything from top to bottom. You can get the slides from all the sessions, including mine at the SQL Saturday 408 event page.
See my complete review
Earlier this year, I wrote about Remote Desktop not returning to fullscreen after minimization in Windows 7. The solution is to use Control-Alt-Break to bring the remote desktop window to full screen. And life was grand. I noticed some comments that people had Laptops where their keyboard did not have a Break key.
Continue reading “Remote Desktop won’t go back to Full Screen Part 2”
Download my slides and source code from my SQL Saturday 97 presentation. Continue reading SQL Saturday 97 Slides and Code – EXCEPT, INTERSECT, APPLY
Incorrect Syntax near go. We’ve all gotten this error before, but why does this happen? Watch a video explaining why you cannot use GO inside of sp_executesql Continue reading Incorrect Syntax Near go revisited
Learn how to add a date printed and a page count in the footer of your SSRS report. Even if you have errors with Globals!OverallTotalPages. Continue reading Display a Page Count in SSRS
I ran into a case when I needed to display some results in the HH:MM:SS format. We all know and love DATEDIFF, which gives you whole number results. Using DATEDIFF, I was getting results like this:
-- Declare some variables for the requested timeframe DECLARE @START_DATE DATETIME DECLARE @END_DATE DATETIME-- Set the timeframe variables SET @START_DATE = '2011-01-01 16:00:00' SET @END_DATE = '2011-01-01 22:47:22' SELECT DATEDIFF(second,@Start_date, @END_DATE) AS Segundos |
Segundos 24442 (1 row(s) affected) |
Continue reading “Using datediff to display results as HH:MM:SS”
Reset and verify IDENTITY values in SQL Server using DBCC. Continue reading Reset an Identity Column in SQL Server
