Viewing 15 posts - 136 through 150 (of 819 total)
Assuming we use DBCC SQLPERF with the parameter LOGSPACE the explanation is wrong.
"Check the amount of space available in a transaction log file."
BOL says the opposite "amount...
June 8, 2017 at 8:46 am
June 8, 2017 at 12:59 am
About the "tempdb", here says that it is configured at the smallest possible size.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-with-minimal-configuration
April 13, 2017 at 2:19 am
Correct and incomplete answer: "This lets me know if the Order table is in the buffer pool", it always returns false.
Ambiguous answer: "This tells me nothing as tables cannot...
March 23, 2017 at 2:38 am
The best method is the following:SELECT COUNT(*) FROM sys.triggers
WHERE parent_id = OBJECT_ID('TriggerTest')
March 2, 2017 at 9:21 am
March 2, 2017 at 9:16 am
March 2, 2017 at 1:20 am
February 14, 2017 at 1:40 am
February 8, 2017 at 3:03 am
DBCC SHRINKFILE (N'mydb_log' , 0, TRUNCATEONLY)February 8, 2017 at 1:59 am
Uncomment the query you want to try:WITH Fullname
AS
(
SELECT * FROM (VALUES
('Erin','Keri','Moody','Sr.')
,('Megan','Laura','Morales','B.S.')
,('George','Lena',NULL,'')
,(NULL,'Ryan','Lucas','M.D.')
,('Sheryl','Marianne','Morton','IV')
) AS V([firstname],[middlename],[lastname],[suffix])
)
--SELECT COALESCE
-- (
-- firstname,...
January 25, 2017 at 9:49 am
January 25, 2017 at 9:46 am
hakan.winther - Wednesday, January 25, 2017 2:28 AMThat was an easy one, thanks! You could also solve this query with CONCAT. 🙂
That's...
January 25, 2017 at 3:27 am
sendijunk (1/11/2017)
Good question. Could use a bit more explanation though. Interesting what happens if you replace ISNULL with COALESCE.
The return type depends on "precedence" of types. In this case, the...
January 11, 2017 at 1:20 am
Viewing 15 posts - 136 through 150 (of 819 total)