Viewing 15 posts - 46 through 60 (of 88 total)
OK, There is no existing index on MasterId on [DetailT] Table. Only PK clustered Index on Id of [DetailT] table.
so, here I have created an index:
CREATE NONCLUSTERED INDEX [NonClusteredIndex-20151203-094659]...
December 2, 2015 at 9:55 pm
To Gail,
As an application developer, few years ago I worked in a software house where we implemented MemCache, I know it is all manual work to understand what we need...
December 2, 2015 at 9:44 pm
In my given scenario, do I need any index or not, back to my first question ? As I asked with sample queries.
December 2, 2015 at 9:12 am
Detail.Id column is already clustered PK index, Do you want me to add another index non clustered (Detail.Id, Detail.MasterId)?
CREATE TABLE [dbo].[MasterT](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NOT NULL,
CONSTRAINT [PK_MasterT]...
December 2, 2015 at 12:42 am
Gila, your answser is not clear to me. From my understanding, are you saying to check existing Index on Detail.Id (should be PK Clustered) and Detail.MasterId (which is referenced from...
November 26, 2015 at 9:57 pm
How you are trying to connect to your server. Write some details about your environment. Like Server OS, SQL Server Version/SP, [Server and client], Client tools you are using to...
November 18, 2015 at 2:48 am
I would suggest using sequence instead of identity
Please explain in simple. Also let me know which SP from my given sample you suggest one should I or everyone use. A...
November 18, 2015 at 2:26 am
1- Check Eventviewer
2- Check disk free space
3- Try login with SQLCMD using [sysadmin] windows login or sa if it works
4- Read database Error Log, what is going on the server.
5-...
November 18, 2015 at 1:47 am
Yes, I already resolved this. You did answer too late. Anyway, thanks
October 26, 2015 at 11:09 am
arr.nagaraj (10/13/2015)
October 13, 2015 at 11:29 am
Please never mind, I resolved it by simple logic below:
Alter TRIGGER [trg_connection_MyServer]
ON ALL SERVER WITH EXECUTE AS 'sa'
FOR LOGON
AS
BEGIN
Declare @Found bit = 0
IF ORIGINAL_LOGIN()= 'Smith'
begin
...
September 9, 2015 at 12:07 pm
i used your given suggestion,
Alter TRIGGER [trg_connection_MyServer]
ON ALL SERVER WITH EXECUTE AS 'sa'
FOR LOGON
AS
BEGIN
IF ORIGINAL_LOGIN()= 'Smith'
begin
if exists (SELECT 1 FROM sys.dm_exec_sessions
WHERE (program_name...
September 9, 2015 at 11:58 am
I have an assignment on this and prepare a presentation for this task in few days. Please do not forget your post on this. I need to resolve it ASAP.
Shamshad...
September 3, 2015 at 10:29 pm
I googled for efficient way of archiving and found partitioning with several advantages. And Please let me know how do I resolve this if partitioning is much complex and not...
September 3, 2015 at 10:52 am
Viewing 15 posts - 46 through 60 (of 88 total)