Search...

I did see one database flooding the log with "starting up" messages and it turns out it has the auto close flag set to true which I will change. Could...

If it needs to be done for many users, creating few roles would be a good idea.

I know couple of tools that generate this kind of temporary tables and the logic inside the tool is not sound enough to drop tables after use. It piles up...

Doesn’t qualify for duplicate but I am sure the thread is connected with this one…

http://www.sqlservercentral.com/Forums/Topic1289178-391-1.aspx

What’s so difficult in the error message? Isn’t it sufficient to explain, you are trying to convert non-qualifying numeric value to integer.

It’s simple. Run a query against the view and pull the execution plan. If you find a predicate on partition id, it indicates partitioning is helping to your query.

More: http://msdn.microsoft.com/en-US/library/ms345599(v=sql.105).aspx

Precisely. I already clarified it in last post ‘if queried upon partitioning key’.

Securable allow us to save database objects that are otherwise given permissions (more like deny) by default. For Example, I can secure few of my tables from as user with...

SQL Server rewrites the query to optimize it so the predicate in the outer query (for view) can be moved to inner query (view definition). It’s very much dependent on...

In addition to what Sean said, what’s the issue you are facing? It pretty simple requirement subject to, you try for it.

In simple words, if you have a table partitioned by Year and you query view / synonyms, both will behave the same way because SQL Server replaces synonyms with actual...

Now it’s turning to database design question than T-SQL question. Please don’t mind, if you are not comfortable in doing the designing please seek for help in your organization. It’s...

It’s a bad design. If you need to add another question in the exam will you alter the table (and keep altering as & when required)? Please redesign it &...

Happy I could help!

Though I agree with Gail on minimizing the use of Dynamic SQL, I do resist classifying it as ‘bad practice’. It’s very powerful to handle the scenarios...