Viewing 15 posts - 3,541 through 3,555 (of 49,571 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.
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 =...
February 22, 2016 at 8:38 am
The first one forces a data type conversion before SQL can compare. The second does not.
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
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.
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).
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...
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...
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/
February 22, 2016 at 2:04 am
Which, while true, has nothing to do with the original question in this 4-year old thread.
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?
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...
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...
February 19, 2016 at 7:35 am
Can you post execution plans of the fast and the slow versions please? Actual plans if possible.
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...
February 19, 2016 at 5:14 am
Viewing 15 posts - 3,541 through 3,555 (of 49,571 total)