Viewing 15 posts - 31 through 45 (of 1,479 total)
That depends on number of rows that belong to an invoice. If they have few lines, most chances are that I'll have only the unique index. On the...
--------------------------------------------------------------
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 7, 2016 at 4:00 am
you can use the function datediff to calculate the difference between 2 points of time.
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 7, 2016 at 3:54 am
I think that you can deny an insert from a dbo. The dbo can change the permissions so he'll be able to use the insert statement but as long...
--------------------------------------------------------------
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 7, 2016 at 1:42 am
You can use the profiler to show that. Another option is to use the extended events. You can see the amount of pages that the query read 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/
December 6, 2016 at 6:16 am
Can you be a bit more specific and give details about the errors?
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 6, 2016 at 3:26 am
Thom A (12/6/2016)
--------------------------------------------------------------
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 6, 2016 at 3:25 am
Check if he is an administrator of the whole server. Anyone that is authenticated as an administrator, can not be limited at all.
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 6, 2016 at 2:57 am
I don't think that this behavior is because of the top clause. I think that this is just the way that SQL Server works with variables. When...
--------------------------------------------------------------
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 5, 2016 at 8:16 am
declare @Primary_Summary table (Med_Rec_Nbr int)
insert into @Primary_Summary (Med_Rec_Nbr) VALUES (1234567),(123456),(12345),(2345678)
SELECT RIGHT(CONCAT('0000000',Med_Rec_Nbr),7)
FROM @Primary_Summary
where LEN(Med_Rec_Nbr) < 7
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 1, 2016 at 9:07 am
Nothing will be effected. TDE was designed to protect your data if someone get a hold on your database's files or backup files. TDE encrypts only the data...
--------------------------------------------------------------
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 1, 2016 at 7:43 am
As this feature's name implies it is completely transparent to the clients, so no code would have to be rewritten. The things that you do have to be aware...
--------------------------------------------------------------
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 1, 2016 at 5:18 am
Removing a user that owns an object from a database is impossible, so if you want to remove this user from the database, you'll have to change the schema's owner...
--------------------------------------------------------------
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 1, 2016 at 4:31 am
User defined functions have some limitations. One of the limitations is that you can't use dynamic SQL in a user defined function, so unfortunately you won't be able to...
--------------------------------------------------------------
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/
November 30, 2016 at 1:42 am
Since you didn't explain much about the results that you need, I also guessed what you want to get. If my guess was not good (and there is 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/
November 29, 2016 at 6:14 am
I read it as BR and have to modify it to B, but this is something that the original poster can modify. I also think that there is 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/
November 15, 2016 at 8:41 am
Viewing 15 posts - 31 through 45 (of 1,479 total)