Temporary Tables

You can create local and global temporary tables. Local temporary tables are visible only in the current session, and global temporary tables are visible to all sessions. Temporary tables...

Hi Steve,

had a good hard look at the site, seen it used elsewhere and I dont like it. for the following reasons.

No real sense of community, which is one of...

you can create a database role and just assign it execute permissions on the sp's that you want the login to execute. add the login/user to the database role.

Your last post shows that your I/O subsystem is struggling to cope. with high disk usage you can see these messages.

Just took your code and ran it, works fine...

I would check the windows logs to see if anything is apparent, it might be an concidence about the scom uninstall, but i would check if the uninstall was successful.

nunucorreia (10/13/2009)

---

Problem is, there's no chance to upgrade hardware. It has been running on a single machine for a while (around 1year), yes, with 100% cpu load spikes once in...

There is only one main reason that developers like security to be data driven, is that depending on the app, they can code functionality into the application that allows permissioning...

This is one way

dbcc sqlperf(logspace)

nunucorreia (10/13/2009)

---

Hello

First of all, I'm no expert in SQL. But need to implement a cluster solution running SQL Server 2005 and I have a simple doubt that I need an...

dont understand that statement, are you saying views are not allowed in your environment. you could as Adi mentioned,...

Well if you are going down the replication route, you could use either transactional or merge, probably better to use transactional uni-directional replication to your replicated/reporting database

gupta1282 (10/13/2009)

---

Respected All

I checked one table from DMV sys.dm_db_index_physical_stats and found avg_fragmentation_in_percent was showing 80% .

Now I Defrage this table using DBReindex but after Again i Checked and found same...

Not sure if the query provided is the best way of doing it, but i can confirm that it works in sql 2000

from BOL

Because the leaf level of a clustered index and the data pages are the same by definition, creating a clustered index and using the ON partition_scheme_name or ON filegroup_name...