Viewing 15 posts - 1,261 through 1,275 (of 1,479 total)
Perry Whittle (12/31/2008)
as Adi pointed out you cannot query the database in the norecovery state. Bear in mind with the standy option when log file restores occur users will be...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 31, 2008 at 10:11 am
Grant Fritchey (12/31/2008)
I think you can do that in 2008, not that it helps you in 2005.
Table valued parameters exist in SQL Server 2008, but it can only be input...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 31, 2008 at 6:39 am
If you want to reset the identity or just see the next number you can use DBCC checkident statement (you can check about it in books on line), but take...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 31, 2008 at 4:35 am
Another option might be to work with temporary table, but that depends on what you are trying to do and how you are doing it.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 31, 2008 at 4:26 am
When you create the log shipping you have 2 choices. You can configure restore log operation to be done with norecovery or with standby option. If you use...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 31, 2008 at 4:18 am
In that case you just need to use grant statement. You can read about it on the internet or on you local copy of books on line at ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/c001c2e7-d092-43d4-8fa6-693b3ec4c3ea.htm
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 30, 2008 at 10:00 pm
You can run sp_spaceused on your tables to find out the table’s size and which table/s uses more space that you thought that they would. Also don’t forget that...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 30, 2008 at 7:46 am
Ashwin M N (12/30/2008)
insert into temp (name) select 'IP 20867 Corona'
insert into temp (name) select '19"-RAC - C60184-03'
insert into temp (name) select 'HEEFA Tower...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 30, 2008 at 7:02 am
Maybe I misunderstand you, but if you want your users to be able to read data from the table and not modify the data, you can grant them read permissions...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 30, 2008 at 4:18 am
If you do have admin privileges, then maybe you misspelled the database’s name. If the server was installed as case sensitive, the database’s name is also case sensitive. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 30, 2008 at 2:32 am
It is better to write a script that creates the tables and inserts data into the table instead of drawing the table and the columns' values. Pleas have a...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 29, 2008 at 11:19 am
Don’t know if it helps you but whenever a database is detached or is shut down (for example, because AUTO_CLOSE is set to ON), all rows associated with the database...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 29, 2008 at 10:44 am
I don’t think that it is supported to change the SQL Server’s name so it will not include the server’s (OS) name. The fallowing is taken from ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/bbaf1445-b8a2-4ebf-babe-17d8cf20b037.htm (How...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 28, 2008 at 6:37 am
Sorry, but I really have no idea about this one.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 27, 2008 at 11:15 pm
Excellent solution and excellent article. Thank you for sharing both of them.
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
December 27, 2008 at 10:41 pm
Viewing 15 posts - 1,261 through 1,275 (of 1,479 total)