Viewing 15 posts - 1,591 through 1,605 (of 2,356 total)
You do not need a temp table.
This should work
CREATE VIEW dbo.YourViewName
WITH SCHEMABINDING
AS
SELECT issue_number,
type_code,
CASE
WHEN alt_type_code...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 19, 2017 at 12:07 pm
No, no, no.
In the VMNew, you are starting SSMS, and connecting to VMOriginal???
That's your first mistake.
When you click connect, database engine, in the server name...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 13, 2017 at 1:58 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 13, 2017 at 11:32 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 7, 2017 at 12:10 pm
Or Pittsburgh
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 5, 2017 at 5:21 am
There's little sense in shrinking tempdb over and over again. This may be a viable option of this was a one-time data load.
The question I have is what...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 31, 2017 at 9:40 am
Let's assume that one of the 6 admins may be the culprit. There is very little that you can do that they cannot undo. Unless you can put auditing on...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 30, 2017 at 2:49 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 25, 2017 at 12:31 pm
It sounds as if the design of your table may not be correct. These are items, possibly an inventory system????
The combination of the manufacturers code, which you may...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 25, 2017 at 11:38 am
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 24, 2017 at 2:30 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 23, 2017 at 8:15 am
The bigger question is why do you ask? What were you thinking of doing?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 22, 2017 at 1:00 pm
Anyone else ever do this?
https://www.sqlshack.com/how-to-spoof-production-environment-resources-for-performance-tuning/#.WRr9Do_GEfw.linkedin
Looks rather interesting...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 18, 2017 at 2:48 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 18, 2017 at 2:46 pm
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
May 18, 2017 at 1:30 pm
Viewing 15 posts - 1,591 through 1,605 (of 2,356 total)