SSMS and scripting
I've heard a lot of complaints about SQL Server Management Studio concerning slowness and some of the things, like scripting...
2006-11-28
1,362 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Default schema
Sadly, I haven't had much experience yet with SQL Server 2005 except for Reporting Services and SSIS. The majority of...
2006-11-27
1,393 reads
Back from PASS
While at PASS, I created a thread in the forums: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=322277 . It was an incredible week. I look forward to...
2006-11-20
1,307 reads
PASS
My daughter-in-law just reminded me on Sunday that her birthday was in 21 days. Yikes! That's the day I fly...
2006-10-26
1,310 reads
Writing Simple Select Statements - Part 3
In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause.
2006-10-26
3,469 reads
Writing Simple Select Statements - Part 2
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
2006-10-12
2,787 reads
Writing Simple Select Statements
In this video, you'll learn how to write basic select statements. This beginner video takes you from the ground up writing T-SQL.
2006-10-04
3,402 reads
Jumpstart TV Video
If you are new to SQL Server, you might be interested in viewing a video that covers the terms you use...
2006-09-11
1,580 reads
RegCreateKeyEX() error
I just began migrating SQL Servers (2000) to Windows 2003 from Windows 2000 a few months ago. In the past, I...
2006-03-27
2,928 reads
PASS 2006 Call for Presentations
For those of you who are interested in speaking at PASS in November, the submission site is open: http://passew.prod.web.sba.com/callpapers/CallPapers.cfm?conference_id=15 .
I encourage...
2006-02-09
1,297 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers