Shhhh!! Be vewy, vewy quiet. I'm hunting Select *!!
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...
2008-03-28
1,544 reads
Who's bad?
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it...
2008-03-28
1,544 reads
"Select *" is bad. Everyone knows it, but everyone still uses it. I use it. Most of the time it is...
2008-03-28
1,457 reads
How do you know what procedures are cached in SQL Server? Simple, just ask, and SQL Server will tell you.You...
2008-03-28
1,489 reads
Here's a good article on setting up Deadlock Notifications in SQL Server 2005 written by Patrick LeBlanc.
2007-10-16
1,496 reads
Q I need an easy way to see if a delete transaction has fired a trigger. Do you have any...
2007-08-01
645 reads
Breaking Up is Easy to DoHardIt's nice to be able to package a process into a single, tidy, elegant query,...
2007-07-03
649 reads
Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking...
2007-07-03
637 reads
The active SQL Server error log is one of the first places people look when there is a problem. For...
2007-06-29
1,626 reads
No, I'm not going to keep making corny references to war and being a soldier. But in many ways, we...
2007-06-29
1,360 reads
Checks the default file locations for your data and log files. If not set, it sets them to the specified values. This is written for a SQL 2005 default instance. Registry paths may be different for SQL 2000 or named instances.The script can be easily modified to update it if the current value is set […]
2007-01-01 (first published: 2006-12-21)
944 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers