Object Grouping Best Practices: Using Schemas for Logical Separation
You've probably all noticed a change since SQL Server 2000 with respect to objects: formerly DB.ObjectOwner.Object ,
2009-07-14
2,920 reads
Schemas
Using the OBJECT_SCHEMA_NAME function to return the schema name
I tend to do a great deal of meta-data (or is it metadata) mining from the system compatibility views and system catalog views in order to build dynamic ad-hoc T/SQL code to use for various administrative processes.
2009-06-22
3,158 reads
Creating a recycle bin for SQL Server 2005\2008
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
2009-05-20
12,872 reads
Using schema binding to improve SQL Server UDF performance
SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.
2009-03-09
4,200 reads
View - Table Usage (Recursive)
Written to explore the table dependencies of a view, especially when the view queries other views.
2009-01-22 (first published: 2009-01-11)
1,102 reads
Getting schemas for your tables
A short script you can incorporate into any 2005/2008 code to get the full schema.table.
2008-09-29
650 reads
Get rid of commas in quoted text, then Bulk Insert
I was trying to use DTS to solve this problem, because DTS can deal with this issue, but I'm a hackboy and DTS is way over my head to automate.I could use bulk insert if I could get past one problem. My CSV data files are garbage, and I have no control over the vendor.Lets […]
2005-01-04
5 reads
RE: IO is frozen for snapshot / IO is thawed
So your server uses internal disk? Does this happen every day? At the same timeframe? Are there any SQL jobs or scheduled tasks running then?
2004-11-24
2 reads
RE: Find Min/Max Values in a Set
I know cursors aren't popular, and most of the times have worse performance, but sometimes they might do the trick elegantly and in this case probably efficiantly (although I haven't checked this)... You can declare a scrollable cursor for the simple "select distinct col from table order by col desc/asc" and then use FETCH RELATIVE […]
2004-11-23
Invalid character value for cast specification
I have an "Execute SQL Task" with input parameter - GlobalVariable gv_RF_ID output parameter - Globalvariable gv_TEXT_INFO gv_RF_ID is INT (default 10322) gv_TEXT_INFO is StringHere is SQL statement: SELECT TEXT_INFO FROM RF_INDEX WHERE RF_ID = ?When I execute this Step I get an error "Invalid character value for cast specification"I ran this statement in QA, […]
2004-10-21
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers