Viewing 15 posts - 826 through 840 (of 2,356 total)
I am using SQL Server 2008 R2 version. Is there any method to store decimal value in SQL without extra trailing zeros(like Float data type format).
Are you using a...
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/
December 14, 2020 at 1:48 pm
We are in the beginning stages of architecting this for our organization. It's not going to be an easy project. Some of the folks on the team think that we...
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/
December 10, 2020 at 3:39 pm
This article may help
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/
December 10, 2020 at 3:34 pm
Honestly, I would create three procedures. One to take the flag and test for its value. That in turn would call one of two other procs. The reason is that...
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/
December 9, 2020 at 3:15 pm
Hello Guys. I dont know if someone can help me here. But is there any way to install windows on iMac?
You would be far better off starting a new...
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/
December 8, 2020 at 7:26 pm
This may get you some of what you want.
SELECT
SS.name SchemaName,
ST.name TableName,
ISNULL(SI.name, '') IndexName,
SI.type_desc IndexType,
IUS.user_updates,
IUS.user_seeks,
IUS.user_scans,
IUS.user_lookups,
SSI.rowcnt,
SSI.rowmodctr,
IUS.last_user_seek,
IUS.last_user_scan,
IUS.last_user_lookup,...
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/
December 8, 2020 at 2:21 pm
If you never query the tables by the ID column you are adding to use in the clustered index, how does it help queries?
If I have a heap table...
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/
December 8, 2020 at 1:30 pm
Because rebuilding the indexes considerably increases the size of the database.
And over time it could be a problem.
Ok, that's normal. It's what you want. You have a 17 GB...
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/
December 3, 2020 at 1:26 am
As a reference, I have a server with 30 databases whose total size is just over 500 GB. The backups run to a UNC, and it takes approximately 40 minutes....
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/
November 27, 2020 at 2:24 pm
Looking at the backup size, it did not change much just about half the size of what it was before... as we do compress our backups it went from...
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/
November 25, 2020 at 1:36 pm
It is KB.
No the files are on the C drive only for both servers.
So somewhat shy of 3GB?
😎
Something is not right here, my tablet regularly processes two times...
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/
November 24, 2020 at 5:27 pm
Always thought that Micro$oft got the SharePoint name wrong, SharePain is far more appropriate 😉 😎
SharePain. I have to remember that.
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/
November 24, 2020 at 3:24 pm
Not exactly.
It appears that there is an issue in the code that is attempting to do the insert. "dbo" is a schema, and for some reason the code is attempting...
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/
November 24, 2020 at 2:14 pm
Sometimes you have to wonder.
I put together an extract of data for one of our clients for monthly invoicing. It's one of those clients that need to have all kinds...
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/
November 24, 2020 at 2:04 pm
Try this link.
https://www.sqlservercentral.com/articles/download-sql-patch-info
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/
November 19, 2020 at 1:29 pm
Viewing 15 posts - 826 through 840 (of 2,356 total)