Search Results

The reason is because the skills for evaluating competence in any discipline are the same skills for competence itself. They thought this design was a good idea because they weren't very skilled in da …

The identity value will be increased if you begin a transaction, insert a row, then rollback the transaction. I originally thought that Access databases could be a culprit in this, thinking that its …

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%word%' Join to the TABLES view if you want to exclude views (TABLE_TYPE = 'BASE TABLE'). If you query sysdatabases or sys.databases …

The Question: As far as I can tell, sp_executesql adds statements to the beginning of submitted dynamic SQL script. But, a SQL Profiler trace does not capture the extra statements, and neither does DB …

From your question I gather that your table is relatively small. As you put more rows in the table you'll find that the bookmark lookup stays about the same, and the scan takes longer and longer. Even …

Why do you have 3 databases with the same users? What happens if one database goes down now? I'm asking these questions because the Con of the user-source database going down preventing use of the o …

CREATE SYNONYM dbo.FooView FOR [LinkedServer].Database.dbo.FooView Then just use dbo.FooView in your SPs and they can be the same between production and dev. Note that this is only for SQL 2005 and …

In Entity SQL, you CAN use aliases from expressions in other places in the query in some situations: select k1, count(t.a), sum(t.a) from T as t group by t.b + t.c as k1 Note that here you MUST def …

Summary There's no logical reason it couldn't be done, but the benefit is small and there are some pitfalls that may not be immediately apparent. Research Results I did some research and found some …

I discovered that the server doesn't put the injected script content into the batch, but into the cached execution plan. So, you can only see this happening in profiler if the executed dynamic SQL is …

Here's a version that accepts any number of trip/route definitions and pulls all the answers at once. Aside from the join to the routes which should perform well with the right indexes, all the trip s …

I just wanted to mention a strategy you may not have considered. It may not be a match here, but it does come in handy sometimes. See if this modification gives you any better performance: SELECT COA …

Initialize @OUT__USER_ID with NULL, since it is probably being set to a non-null value earlier in your script somewhere.

Here's a way to show what was asked for: SELECT Which = 'TableA', * FROM ( SELECT * FROM dbo.TableA EXCEPT SELECT * FROM dbo.TableB ) X UNION ALL SELECT 'TableB', * FROM ( SEL …

I have backed up and restored many a SQL Server database using T-SQL script, but always FROM DISK or TO DISK. I am not a provisioning-concerned database administrator, though, so don't have as much ex …