Viewing 15 posts - 331 through 345 (of 1,479 total)
I don't think that you need permission to view query plan on tempdb if you are using temporary tables. I've just tried it with this code:
create login testing with...
--------------------------------------------------------------
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/
May 21, 2012 at 10:33 am
I've given permissions to view query plans to few developers and testers at Dev and QA environments. I admit that it is rare that I'm granting this permission, but...
--------------------------------------------------------------
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/
May 21, 2012 at 10:15 am
The 2 backups work differently, so there isn't a connection between the sizes of differential backup and full backup. The full backup will back up the entire database regardless...
--------------------------------------------------------------
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/
May 21, 2012 at 9:55 am
If I remember correctly DBCC cleantable reclaims disk space only on tables that varying length columns were dropped from. It doesn't reclaim disk space if the column still exists...
--------------------------------------------------------------
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/
May 21, 2012 at 2:33 am
You are using dynamic SQL to construct the SQL Statement that is creating the temporary table. If you are concatenating a variable that is null, the whole statement is...
--------------------------------------------------------------
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/
May 9, 2012 at 2:22 am
I tend to agree with your friend. I think that the data type that should be used is the smallest one that can be used and hold all...
--------------------------------------------------------------
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/
May 8, 2012 at 4:27 am
moorthy.jy (5/7/2012)
Thanks. Basically, i was trying to findout the difference in seconds between 2 given dates.
In that case, you should use the function datediff.
SELECT datediff(SS,'2012-05-06 11:07:09.313', '2012-05-06 11:07:09.317')
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/
May 7, 2012 at 4:28 am
Check the results of this query:
select CAST('2012-05-06 11:07:09.313' AS DATETIME) - CAST('2012-05-06 11:07:09.317' AS DATETIME)
The result of this query is - 1899-12-31 23:59:59.997. I have to admit 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/
May 7, 2012 at 3:56 am
The with clause can have a third part that describes the location of the node. If you'll add it, you'll be able to get the data that you want....
--------------------------------------------------------------
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/
May 7, 2012 at 1:48 am
You don't need to delete the data. You have to drop the primary key and the index IND_HIM8 before modifying the collation. After you create it you can...
--------------------------------------------------------------
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/
May 2, 2012 at 1:49 am
As far as I remember when you rebuild the index the statistics are getting updated, so there is no reason to update the statistics again. If you just reorganize...
--------------------------------------------------------------
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/
May 1, 2012 at 6:50 am
One more way, that uses the same logic as Sean, but uses a CTE instead of derived table.
with MyTests as(
select L.Name, TestDate, PfReal, row_number() over (partition by L.Name...
--------------------------------------------------------------
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/
April 24, 2012 at 9:55 am
If the indexes that you have were not in use for 3 months as you wrote, then there is no reason to have them and you can drop them. ...
--------------------------------------------------------------
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/
April 24, 2012 at 8:23 am
If the user has both deny and grant permissions, the deny wins:-). Check if your user also had deny permissions on the table or if he is a member...
--------------------------------------------------------------
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/
March 16, 2012 at 12:14 pm
I don’t think that developers should have the permissions in the production environment. They should have permissions on the dev environment, but there is no reason to give them...
--------------------------------------------------------------
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/
March 16, 2012 at 12:07 pm
Viewing 15 posts - 331 through 345 (of 1,479 total)