Viewing 15 posts - 3,541 through 3,555 (of 49,552 total)
It's a table valued function, so join to it. Instead of WHERE IN, join to the function on the column that you're filtering by.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 9:04 am
Google: DelimitedSplit8k
Use the function in the article
btw, it's working exactly as expected in all cases (but maybe not how you hoped though)
FieldOnTableCallType IN (@prmCallType) is equivalent to FieldOnTableCallType =...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 8:38 am
The first one forces a data type conversion before SQL can compare. The second does not.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 7:26 am
Please don't post multiple questions for the same problem.
http://www.sqlservercentral.com/Forums/Topic1762934-392-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 6:51 am
Check the path variable for the SQL Agent service account. Path variables are profile specific, and SQL Agent doesn't use your login to run.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 6:33 am
Like Fantasy and crime/detective stories?
If so, Rivers of London (also published under the name "Midnight Riot" in the US).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 6:32 am
Gary Varga (2/22/2016)
Given that there are even cloud sandboxes for most things now it does beg the question why anyone would not use cloud hosts.
Bandwidth. Latency.
My current company...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 4:47 am
A partition switch can only be done within the same database.
You'll need to create non-partitioned tables in the same DB as the partitioned table (same filegroup as the destination...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 2:45 am
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
My first guess would be full recovery model, no log backups.
This may also be useful
http://www.sqlservercentral.com/articles/Administration/64582/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 2:04 am
Which, while true, has nothing to do with the original question in this 4-year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 2:03 am
Rebuilding a clustered index may fix it, if the error is in the allocation pages as it appeared to be.
If you run CheckDB WITH NO_INFOMSGS, does it return any errors?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 22, 2016 at 2:02 am
LittleTony (2/19/2016)
GilaMonster (2/19/2016)
"An explicit value for identity column in table dbo.N8_SPEC_STAT_DELETED can only be specified when a column list is used and IDENTITY_INSERT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2016 at 11:23 am
The cause is detailed in the error message.
"An explicit value for identity column in table dbo.N8_SPEC_STAT_DELETED can only be specified when a column list is used and IDENTITY_INSERT is ON"
You...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2016 at 7:35 am
Can you post execution plans of the fast and the slow versions please? Actual plans if possible.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2016 at 7:10 am
And keep in mind that for a query to use a filtered index, the filter in the query WHERE clause has to match or be an easily determined subset of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2016 at 5:14 am
Viewing 15 posts - 3,541 through 3,555 (of 49,552 total)